{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Pres & Prop Rev","Rate Design","Appendix F Pg 4","COS","Appendix F Pg 6","ROR","Bill Determ","Rate Spread","Sch 177","Residential Bill","Big Schedules","Rev Runs CY","Block Analysis"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":18,"comments":5,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Pres & Prop Rev","index":0,"n_rows":225,"n_cols":16,"rows_kept":225,"cut":false,"hidden":false,"merged":[[5,15,10,17]]}
[]
["Effective September 1, 2024"]
[null,null,null,null,null,null,null,"ALERIS","CLEARWATER"]
[null,null," ","GEN SERVICE","LRG GEN SVC","INTERRUPTIBLE","TRANSPORT","TRANSPORT","TRANSPORT"]
[null,null,"TOTAL","SCHEDULE 101","SCH. 111&112","SCH. 131&132","SCHEDULE 146","SCHEDULE 147","SCHEDULE 159",null,null,null,null,null,null,"Print Header for all printed pages on this worksheet:"]
[null,"PRESENT BILL DETERMINANTS",null,null,null,null,null,null,null,null,null,"Calculate all revenue exhibits using  ____ rates:",null,null,null,{"$f":"\"AVISTA UTILITIES\nIDAHO GAS, CASE NO. AVU-G-23-01\nPRO FORMA REVENUE UNDER PRESENT AND PROPOSED \"&N9&\" RATES\n12 MONTHS ENDED JUNE 30, 2022\"","v":"AVISTA UTILITIES\nIDAHO GAS, CASE NO. AVU-G-23-01\nPRO FORMA REVENUE UNDER PRESENT AND PROPOSED BASE TARIFF RATES\n12 MONTHS ENDED JUNE 30, 2022"}]
[null,"THERMS",null,null,null,null,null,null,null,null,"1)","BASE TARIFF"]
[null,"BLOCK 1",null,{"$f":"'Bill Determ'!B8","v":70027024.203949988},{"$f":"'Bill Determ'!B15","v":3283296.1716},{"$f":"'Bill Determ'!B25","v":0.1},{"$f":"'Bill Determ'!B29","v":3922248},{"$f":"'Big Schedules'!N46","v":1314220},{"$f":"'Bill Determ'!B35","v":51912883},null,null,"or",null,1]
[null,"BLOCK 2",null,null,{"$f":"'Bill Determ'!C15","v":8247668.8472199989},null,null,null,null,null,"2)","BILLING",null,{"$f":"CHOOSE(Base1_Billing2,L7,L9)","v":"BASE TARIFF"}]
[null,"BLOCK 3",null,null,{"$f":"'Bill Determ'!D15","v":11206259.59857},{"$f":"'Bill Determ'!D25","v":0},{"$f":"'Bill Determ'!D29","v":0},null,null,null,null,null,null,{"$f":"CHOOSE(Base1_Billing2,\"Base\",\"Billing\")","v":"Base"}]
[null,"BLOCK 4",null,null,{"$f":"'Bill Determ'!E15","v":3500647.9710199996},{"$f":"'Bill Determ'!E25","v":0},{"$f":"'Bill Determ'!E29","v":0}]
[null,"BLOCK 5",null,null,null,null,{"$f":"'Bill Determ'!F29","v":0}]
[]
[null,"SUBTOTAL",{"$f":"SUM(D14:I14)","v":153414247.89235997},{"$f":"SUM(D8:D12)","v":70027024.203949988},26237872.588409998,0.1,{"$f":"SUM(G8:G12)","v":3922248},{"$f":"SUM(H8:H12)","v":1314220},51912883]
[null,"LOAD ADJUSTMENT"]
[]
[null,"SUBTOTAL",{"$f":"SUM(D17:I17)","v":153414247.89235997},{"$f":"D14+D15","v":70027024.203949988},26237872.588409998,0.1,{"$f":"G14+G15","v":3922248},1314220,51912883]
[null,"ADJUSTMENT TO ACTUAL",{"$f":"SUM(D18:I18)","v":0},null,{"$f":"'Bill Determ'!F21","v":0}]
[]
[null,"TOTAL BEFORE ADJUSTMENT",{"$f":"SUM(D20:I20)","v":153414247.89235997},{"$f":"D17+D18","v":70027024.203949988},26237872.588409998,0.1,{"$f":"G17+H18","v":3922248},{"$f":"H17+H18","v":1314220},51912883]
[null,"WEATHER & UNBILLED REV. ADJ.",{"$f":"SUM(D21:I21)","v":-710273},{"$f":"D134+D137","v":-547518},-162755,0,{"$f":"G134+G137","v":0},0,0]
[]
[null,"TOTAL PROFORMA THERMS",{"$f":"IF(ROUND(SUM(C20:C21),3)<>ROUND(SUM(D23:I23),3),#VALUE!,SUM(D23:I23))","v":152703974.89235997},{"$f":"SUM(D20:D21)","v":69479506.203949988},26075117.588409998,0.1,{"$f":"SUM(G20:G21)","v":3922248},1314220,51912883]
[]
[null,"TOTAL BILLS",null,{"$f":"'Bill Determ'!C8","v":1079689},null,{"$f":"'Bill Determ'!C25","v":0},{"$f":"'Bill Determ'!C29","v":72},{"$f":"'Bill Determ'!C32","v":12},{"$f":"'Bill Determ'!C35","v":12}]
[null,"TOTAL MINIMUM BILLS",null,null,{"$f":"'Bill Determ'!G15","v":18727}]
[]
[]
[null,"PROPOSED BILL DETERMINANTS"]
[null,"THERMS"]
[null,"BLOCK 1",null,{"$f":"D8","v":70027024.203949988},{"$f":"'Bill Determ'!B15","v":3283296.1716},{"$f":"F8","v":0.1},3922248,1314220,51912883]
[null,"BLOCK 2",null,{"$f":"D9","v":0},{"$f":"'Bill Determ'!C15","v":8247668.8472199989},0,0,0,0]
[null,"BLOCK 3",null,{"$f":"D10","v":0},{"$f":"'Bill Determ'!D15","v":11206259.59857},0,0,0,0]
[null,"BLOCK 4",null,{"$f":"D11","v":0},{"$f":"'Bill Determ'!E15","v":3500647.9710199996},0,0,0,0]
[null,"BLOCK 5",null,{"$f":"D12","v":0},{"$f":"E12","v":0},{"$f":"F12","v":0},{"$f":"G12","v":0},{"$f":"H12","v":0},{"$f":"I12","v":0}]
[]
[null,"SUBTOTAL",{"$f":"SUM(D37:I37)","v":153414247.89235997},{"$f":"SUM(D31:D35)","v":70027024.203949988},26237872.588409998,0.1,{"$f":"SUM(G31:G35)","v":3922248},{"$f":"SUM(H31:H35)","v":1314220},51912883]
[null,"NET SHIFTING ADJUSTMENT",{"$f":"SUM(D38:I38)","v":0},{"$f":"D15","v":0},0,0,{"$f":"G15","v":0},0,0]
[]
[null,"SUBTOTAL",{"$f":"SUM(D40:I40)","v":153414247.89235997},{"$f":"D37+D38","v":70027024.203949988},26237872.588409998,0.1,{"$f":"G37+G38","v":3922248},1314220,51912883]
[null,"ADJUSTMENT TO ACTUAL",{"$f":"SUM(D41:I41)","v":0},{"$f":"D18","v":0},0,0,0,0,0]
[]
[null,"TOTAL BEFORE ADJUSTMENT",{"$f":"SUM(D43:I43)","v":153414247.89235997},{"$f":"D40+D41","v":70027024.203949988},26237872.588409998,0.1,{"$f":"G40+G41","v":3922248},{"$f":"H40+H41","v":1314220},51912883]
[null,"WEATHER & UNBILLED REV. ADJ.",{"$f":"SUM(D44:I44)","v":-710273},{"$f":"D21","v":-547518},-162755,0,{"$f":"G21","v":0},0,0]
[]
[null,"TOTAL PROFORMA THERMS",{"$f":"IF(ROUND(SUM(C43:C44),3)<>ROUND(SUM(D46:I46),3),#VALUE!,SUM(D46:I46))","v":152703974.89235997},{"$f":"D43+D44","v":69479506.203949988},26075117.588409998,0.1,{"$f":"G43+G44","v":3922248},1314220,51912883]
[]
[null,"TOTAL BILLS",null,{"$f":"D25","v":1079689},0,0,72,12,12]
[null,"TOTAL MINIMUM BILLS",null,{"$f":"D26","v":0},{"$f":"'Bill Determ'!G15","v":18727}]
[]
[null,null,null,1,2,3,4,5,6]
[null,null,null,null,null,null,null,"ALERIS","CLEARWATER"]
[null,null," ","GEN SERVICE","LRG GEN SVC","INTERRUPTIBLE","TRANSPORT","TRANSPORT","TRANSPORT",null,null,{"$f":"\"selected in cell \"&CELL(\"address\",Base1_Billing2)&\":\"","v":"selected in cell $N$8:"}]
[null,null,"TOTAL","SCHEDULE 101","SCHEDULE 111","SCHEDULE 131","SCHEDULE 146","SCHEDULE 147","SCHEDULE 159",null,null,{"$f":"N10","v":"Base"}]
[null,"PRESENT RATES",null,null,null,null,null,-1,-2,null,null,{"$f":"\"Rates_\"&$L$54&\"_Present\"","v":"Rates_Base_Present"},null,"- range name where Present Rates table can be found"]
[null,"BASIC CHARGE",null,{"$f":"INDEX(INDIRECT($L$55),$J56,D$51)","v":15},0,0,300,null,{"$f":"'Big Schedules'!N66/12","v":6166.6699999999992},1,null,{"$f":"\"Rates_\"&$L$54&\"_Proposed\"","v":"Rates_Base_Proposed"},null,"- range name where Proposed Rates table can be found"]
[null,"MONTHLY MINIMUM",null,0,81.739999999999995,0,0,null,null,2]
[]
[null,"BLOCK 1 PER THERM",null,{"$f":"INDEX(INDIRECT($L$55),$J59,D$51)","v":33.371000000000002},0,20.379000000000001,12.231999999999999,2,null,3]
[null,"BLOCK 2 PER THERM",null,0,32.368000000000002,0,0,null,null,4]
[null,"BLOCK 3 PER THERM",null,0,23.574999999999999,0,0,null,null,5]
[null,"BLOCK 4 PER THERM",null,0,17.763999999999999,0,0,null,null,6]
[null,"BLOCK 5 PER THERM",null,0,0,0,0,null,null,7]
[]
[null,"ADJUST TO ACTUAL PER THERM",null,null,{"$f":"(E118-E106-E107)/E17*100","v":22.613633174744969},{"$f":"(F118-F106-F107)/F17*100","v":20}]
[]
[]
[]
[]
[]
[]
[]
[null,"PROPOSED RATES"]
[null,"BASIC CHARGE",null,{"$f":"INDEX(INDIRECT($L$56),$J74,D$51)","v":20},0,0,300,null,{"$f":"'Big Schedules'!N66/12","v":6166.6699999999992},1]
[null,"MONTHLY MINIMUM",null,0,71.209999999999994,0,0,null,null,2]
[]
[null,"BLOCK 1 PER THERM",null,{"$f":"INDEX(INDIRECT($L$56),$J77,D$51)","v":25.605},0,20.379000000000001,12.231999999999999,2,null,3]
[null,"BLOCK 2 PER THERM",null,0,33.451000000000001,0,0,null,null,4]
[null,"BLOCK 3 PER THERM",null,0,24.364000000000001,0,0,null,null,5]
[null,"BLOCK 4 PER THERM",null,0,18.358000000000001,0,0,null,null,6]
[null,"BLOCK 5 PER THERM",null,0,0,0,0,null,null,7]
[]
[null,"ADJUST TO ACTUAL PER THERM",null,null,{"$f":"(E167-E155-E156)/E40*100","v":23.370300809786759},{"$f":"(F167-F155-F156)/F40*100","v":20}]
[]
[]
[]
[null,"(1) Block 1 - ALERIS - workpaper PDE-G-17"]
[]
[null,"(2) Monthly minimum / rate per therm - workpaper PDE-G-19"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"A2","v":"Effective September 1, 2024"}]
[null,null,null,null,null,null,null,"ALERIS","CLEARWATER"]
[null,null," ","GEN SERVICE","LRG GEN SVC","INTERRUPTIBLE","TRANSPORT","TRANSPORT","TRANSPORT"]
[null,null,"TOTAL","SCHEDULE 101","SCHEDULE 111","SCHEDULE 131","SCHEDULE 146","SCHEDULE 147","SCHEDULE 159"]
[null,"PRESENT REVENUE"]
[null,{"$f":"UPPER(CHOOSE(Base1_Billing2,$N$9,$N$10))&\" REVENUE\"","v":"BASE TARIFF REVENUE"}]
[null,"BASIC CHARGE",{"$f":"SUM(D106:I106)","v":16290935.039999999},{"$f":"D25*D56","v":16195335},0,0,{"$f":"G25*G56","v":21600},0,{"$f":"I25*I56","v":74000.039999999994}]
[null,"MONTHLY MINIMUM",1530744.98,0,{"$f":"E26*E57","v":1530744.98},0,{"$f":"'Big Schedules'!V11","v":0},0,0]
[null,"BLOCK 1",23874772.049999997,{"$f":"ROUND(D8*D59/100,2)","v":23368718.25},{"$f":"ROUND(E8*E59/100,2)","v":0},{"$f":"ROUND(F8*F59/100,2)","v":0.02},479769.38,26284.400000000001,0]
[null,"BLOCK 2",2669605.4500000002,0,2669605.4500000002,0,0,0,0]
[null,"BLOCK 3",2641875.7000000002,0,2641875.7000000002,0,0,0,0]
[null,"BLOCK 4",621855.11,{"$f":"ROUND(D11*D62/100,2)","v":0},621855.11,0,0,0,0]
[null,"BLOCK 5",0,{"$f":"ROUND(D12*D63/100,2)","v":0},0,0,0,0,0]
[null,"ANNUAL MINIMUM",0]
[]
[null,"SUBTOTAL",{"$f":"IF(ROUND(SUM(D115:I115),3)<>ROUND(SUM(C106:C113),3),#VALUE!,SUM(D115:I115))","v":47629788.330000006},{"$f":"SUM(D106:D113)","v":39564053.25},7464081.2400000002,0.02,501369.38,26284.400000000001,74000.039999999994]
[null,"NET SHIFTING ADJUSTMENT"]
[]
[null,"SUBTOTAL",{"$f":"SUM(D118:I118)","v":47629788.330000006},{"$f":"D115+D116","v":39564053.25},7464081.2400000002,0.02,501369.38,26284.400000000001,74000.039999999994]
[null,"ADJUST TO ACTUAL",{"$f":"SUM(D119:I119)","v":0},{"$f":"ROUND(D18*D65/100,2)","v":0},{"$f":"ROUND(E18*E65/100,2)","v":0},0,0,0,0]
[]
[null,{"$f":"\"TOTAL \"&UPPER(CHOOSE(Base1_Billing2,$N$9,$N$10))&\" REVENUE\"","v":"TOTAL BASE TARIFF REVENUE"},{"$f":"IF(ROUND(C118+C119,3)<>ROUND(SUM(D121:I121),3),#VALUE!,SUM(D121:I121))","v":47629788.330000006},{"$f":"D118+D119","v":39564053.25},7464081.2400000002,0.02,501369.38,26284.400000000001,74000.039999999994]
[]
[]
[null,"ADJUSTMENT REVENUE"]
[null,"UNBILLED REVENUE ADJUSTMENT"]
[null,"UNBILLED LOAD THERMS",{"$f":"SUM(D126:I126)","v":46442},{"$f":"'Rev Runs CY'!P62","v":72164},{"$f":"'Rev Runs CY'!P63","v":-25722}]
[null,"UNBILLED LOAD RATE",null,{"$f":"D59","v":33.371000000000002},{"$f":"E211","v":22.613633168658502}]
[null,"UNBILLED LOAD REVENUE",{"$f":"SUM(D128:I128)","v":18265.169999999998},{"$f":"ROUND(D126*D127/100,2)","v":24081.85},{"$f":"ROUND(E126*E127/100,2)","v":-5816.68}]
[]
[null,"WEATHER-SENSITIVE THERMS",{"$f":"SUM(D130:I130)","v":0},0,0]
[null,"WEATHER-SENSITIVE RATE",null,{"$f":"D59","v":33.371000000000002},{"$f":"I211","v":22.15704777289109}]
[null,"WEATHER-SENSITIVE REVENUE",{"$f":"SUM(D132:I132)","v":0},{"$f":"ROUND(D130*D131/100,2)","v":0},{"$f":"ROUND(E130*E131/100,2)","v":0}]
[]
[null,"TOTAL UNBILLED THERM ADJ",{"$f":"IF(ROUND(SUM(D134:I134),3)<>ROUND(C126+C130,3),#VALUE!,SUM(D134:I134))","v":46442},{"$f":"D126+D130","v":72164},{"$f":"E126+E130","v":-25722}]
[null,"TOTAL UNBILLED REVENUE ADJ",{"$f":"IF(ROUND(SUM(D135:I135),3)<>ROUND(C128+C132,3),#VALUE!,SUM(D135:I135))","v":18265.169999999998},{"$f":"D128+D132","v":24081.85},{"$f":"E128+E132","v":-5816.68}]
[null,"WEATHER NORMALIZATION ADJ"]
[null,"WEATHER-SENSITIVE THERMS",{"$f":"SUM(D137:I137)","v":-756715},-619682,-137033]
[null,"WEATHER-SENSITIVE RATE",null,{"$f":"D127","v":33.371000000000002},{"$f":"I211","v":22.15704777289109}]
[null,"WEATHER-SENSITIVE REVENUE",{"$f":"SUM(D139:I139)","v":-237156.55},{"$f":"ROUND(D137*D138/100,2)","v":-206794.08},{"$f":"ROUND(E137*E138/100,2)","v":-30362.47}]
[null,"OTHER ADJUSTMENTS"]
[]
[null,"TOTAL ADJUSTMENT REVENUE",{"$f":"IF(ROUND(SUM(D142:I142),3)<>ROUND(C135+C139+C140,3),#VALUE!,SUM(D142:I142))","v":-218891.37999999998},{"$f":"D135+D139+D140","v":-182712.22999999998},-36179.15,0,0,0,0]
[null,{"$f":"B121","v":"TOTAL BASE TARIFF REVENUE"},{"$f":"SUM(D143:I143)","v":47629788.330000006},{"$f":"D121","v":39564053.25},7464081.2400000002,0.02,501369.38,26284.400000000001,74000.039999999994]
[]
[null,"TOTAL PRESENT REVENUE",{"$f":"IF(ROUND(SUM(D145:I145),3)<>ROUND(C142+C143,3),#VALUE!,SUM(D145:I145))","v":47410896.950000003},{"$f":"D142+D143","v":39381341.020000003},7427902.0899999999,0.02,501369.38,26284.400000000001,74000.039999999994]
[]
[]
[]
[{"$f":"A2","v":"Effective September 1, 2024"}]
[null,null,null,null,null,null,null,"ALERIS","CLEARWATER"]
[null,null," ","GEN SERVICE","LRG GEN SVC","INTERRUPTIBLE","TRANSPORT","TRANSPORT","TRANSPORT"]
[null,null,"TOTAL","SCHEDULE 101","SCHEDULE 111","SCHEDULE 131","SCHEDULE 146","SCHEDULE 147","SCHEDULE 159"]
[null,"PROPOSED REVENUE"]
[null,{"$f":"UPPER(CHOOSE(Base1_Billing2,$N$9,$N$10))&\" REVENUE\"","v":"BASE TARIFF REVENUE"}]
[null,"BASIC CHARGE",{"$f":"SUM(D155:I155)","v":21689380.039999999},{"$f":"D48*D74","v":21593780},{"$f":"E48*E74","v":0},0,21600,0,74000.039999999994]
[null,"MONTHLY MINIMUM",1333549.67,{"$f":"D49*D75","v":0},1333549.67,0,{"$f":"'Big Schedules'!Z11","v":0},0,0]
[null,"BLOCK 1",18436473.349999998,{"$f":"ROUND(D31*D77/100,2)","v":17930419.550000001},0,0.02,479769.38,26284.400000000001,0]
[null,"BLOCK 2",2758927.71,{"$f":"ROUND(D32*D78/100,2)","v":0},2758927.71,0,0,0,0]
[null,"BLOCK 3",2730293.09,0,2730293.09,0,0,0,0]
[null,"BLOCK 4",642648.94999999995,0,642648.94999999995,0,0,0,0]
[null,"BLOCK 5",0,0,0,0,0,0,0]
[null,"ANNUAL MINIMUM",0]
[]
[null,"SUBTOTAL",{"$f":"IF(ROUND(SUM(D164:I164),3)<>ROUND(SUM(C155:C162),3),#VALUE!,SUM(D164:I164))","v":47591272.810000002},{"$f":"SUM(D155:D163)","v":39524199.549999997},7465419.4199999999,0.02,501369.38,26284.400000000001,74000.039999999994]
[null,"NET SHIFTING ADJUSTMENT"]
[]
[null,"SUBTOTAL",{"$f":"SUM(D167:I167)","v":47591272.810000002},{"$f":"D164+D165","v":39524199.549999997},7465419.4199999999,0.02,{"$f":"G164+G165","v":501369.38},26284.400000000001,74000.039999999994]
[null,"ADJUST TO ACTUAL",{"$f":"SUM(D168:I168)","v":0},{"$f":"ROUND(D41*D83/100,2)","v":0},0,0,0,0,0]
[]
[null,{"$f":"\"TOTAL \"&UPPER(CHOOSE(Base1_Billing2,$N$9,$N$10))&\" REVENUE\"","v":"TOTAL BASE TARIFF REVENUE"},{"$f":"IF(ROUND(SUM(D170:I170),3)<>ROUND(C167+C168,3),#VALUE!,SUM(D170:I170))","v":47591272.810000002},{"$f":"D167+D168","v":39524199.549999997},7465419.4199999999,0.02,{"$f":"G167+G168","v":501369.38},26284.400000000001,74000.039999999994]
[]
[null,"ADJUSTMENT REVENUE"]
[null,"UNBILLED REVENUE ADJUSTMENT"]
[null,"BASE LOAD THERMS",{"$f":"SUM(D174:I174)","v":46442},{"$f":"D126","v":72164},{"$f":"E126","v":-25722}]
[null,"BASE LOAD RATE",null,{"$f":"D77","v":25.605},{"$f":"E221","v":23.370300806733955}]
[null,"BASE LOAD REVENUE",{"$f":"SUM(D176:I176)","v":12466.279999999999},{"$f":"ROUND(D174*D175/100,2)","v":18477.59},{"$f":"ROUND(E174*E175/100,2)","v":-6011.31}]
[]
[null,"WEATHER-SENSITIVE THERMS",{"$f":"SUM(D178:I178)","v":0},{"$f":"D130","v":0},{"$f":"E130","v":0}]
[null,"WEATHER-SENSITIVE RATE",null,{"$f":"D77","v":25.605},{"$f":"I221","v":22.898465483390794}]
[null,"WEATHER-SENSITIVE REVENUE",{"$f":"SUM(D180:I180)","v":0},{"$f":"ROUND(D178*D179/100,2)","v":0},{"$f":"ROUND(E178*E179/100,2)","v":0}]
[]
[null,"TOTAL UNBILLED THERM ADJ",{"$f":"C174+C178","v":46442},{"$f":"D174+D178","v":72164},{"$f":"E174+E178","v":-25722}]
[null,"TOTAL UNBILLED REVENUE ADJ",{"$f":"C176+C180","v":12466.279999999999},{"$f":"D176+D180","v":18477.59},{"$f":"E176+E180","v":-6011.31}]
[null,"WEATHER NORMALIZATION ADJ"]
[null,"WEATHER-SENSITIVE THERMS",{"$f":"SUM(D185:I185)","v":-756715},{"$f":"D137","v":-619682},{"$f":"E137","v":-137033}]
[null,"WEATHER-SENSITIVE RATE",null,{"$f":"D179","v":25.605},{"$f":"E179","v":22.898465483390794}]
[null,"WEATHER-SENSITIVE REVENUE",{"$f":"SUM(D187:I187)","v":-190048.03},{"$f":"ROUND(D185*D186/100,2)","v":-158669.57999999999},{"$f":"ROUND(E185*E186/100,2)","v":-31378.45}]
[null,"OTHER ADJUSTMENTS"]
[]
[null,"TOTAL ADJUSTMENT REVENUE",{"$f":"SUM(D190:I190)","v":-177581.75},{"$f":"D187+D183","v":-140191.99},-37389.760000000002,0,{"$f":"G187+G183","v":0},0,0]
[null,{"$f":"B170","v":"TOTAL BASE TARIFF REVENUE"},{"$f":"SUM(D191:I191)","v":47591272.810000002},{"$f":"D170","v":39524199.549999997},{"$f":"E170","v":7465419.4199999999},0.02,{"$f":"G170","v":501369.38},26284.400000000001,74000.039999999994]
[null,"TOTAL PROPOSED REVENUE",{"$f":"SUM(D192:I192)","v":47413691.060000002},{"$f":"D190+D191","v":39384007.559999995},{"$f":"E190+E191","v":7428029.6600000001},0.02,{"$f":"G190+G191","v":501369.38},26284.400000000001,74000.039999999994]
[null,"TOTAL PRESENT REVENUE",{"$f":"SUM(D193:I193)","v":47410896.950000003},{"$f":"D145","v":39381341.020000003},{"$f":"E145","v":7427902.0899999999},0.02,{"$f":"G145","v":501369.38},26284.400000000001,74000.039999999994]
[]
[null,"TOTAL INCREASED REVENUE",{"$f":"SUM(D195:I195)","v":2794.1099999919534},{"$f":"D192-D193","v":2666.5399999916553},{"$f":"E192-E193","v":127.57000000029802},{"$f":"F192-F193","v":0},{"$f":"G192-G193","v":0},0,0]
[null,"PERCENT REVENUE INCREASE",{"$f":"C195/C193","v":5.8933919831524161E-5},6.7710746534442297E-5,1.7174432087903037E-5,{"$f":"F195/F193","v":0},0,0,0]
[]
[]
[]
[null,null," ","TOTAL","TOTAL","BASE LOAD","BASE LOAD","WTHR-SENS.","WTHR-SENS."]
[null,null,"RATES","THERMS","REVENUE","THERMS(1)","REVENUE","THERMS","REVENUE"]
[]
[null,"PRESENT BASELOAD AND WEATHER-SENSITIVE RATE"]
[null,"SCHEDULE 111"]
[null,"0-200 THERMS",{"$f":"E59","v":0},{"$f":"E8","v":3283296.1716},{"$f":"C205*D205/100","v":0},{"$f":"MIN(D205,F210)","v":3283296.1716},{"$f":"F205*C205/100","v":0},{"$f":"D205-F205","v":0},{"$f":"H205*C205/100","v":0}]
[null,"201-1,000 THERMS",{"$f":"E60","v":32.368000000000002},{"$f":"E9","v":8247668.8472199989},{"$f":"C206*D206/100","v":2669605.4524681694},{"$f":"MIN(F210-F205,D206)","v":8247668.8472199989},{"$f":"F206*C206/100","v":2669605.4524681694},{"$f":"D206-F206","v":0},{"$f":"H206*C206/100","v":0}]
[null,"1,001-10,000 THERMS",{"$f":"E61","v":23.574999999999999},{"$f":"E10","v":11206259.59857},{"$f":"C207*D207/100","v":2641875.7003628775},{"$f":"MIN(F210-F205-F206,D207)","v":360679.98118000198},{"$f":"F207*C207/100","v":85030.305563185451},{"$f":"D207-F207","v":10845579.617389999},{"$f":"H207*C207/100","v":2556845.3947996926}]
[null,"OVER 10,000 THERMS",{"$f":"E62","v":17.763999999999999},{"$f":"E11","v":3500647.9710199996},{"$f":"C208*D208/100","v":621855.1055719927},{"$f":"MIN(F210-F205-F206-F207,D208)","v":0},{"$f":"F208*C208/100","v":0},{"$f":"D208-F208","v":3500647.9710199996},{"$f":"H208*C208/100","v":621855.1055719927}]
[]
[null,"TOTAL",null,{"$f":"SUM(D205:D208)","v":26237872.588409998},{"$f":"SUM(E205:E208)","v":5933336.2584030395},{"$f":"635*E26","v":11891645},{"$f":"SUM(G205:G208)","v":2754635.7580313548},{"$f":"SUM(H205:H208)","v":14346227.588409999},{"$f":"SUM(I205:I208)","v":3178700.5003716853}]
[null,"AVERAGE RATE",null,null,{"$f":"E210/D210*100","v":22.613633168658502},null,{"$f":"G210/F210*100","v":23.164463436567058},null,{"$f":"I210/H210*100","v":22.15704777289109}]
[]
[null,"PROPOSED BASELOAD AND WEATHER-SENSITIVE RATE"]
[null,"SCHEDULE 111"]
[null,"0-200 THERMS",{"$f":"E77","v":0},{"$f":"E31","v":3283296.1716},{"$f":"C215*D215/100","v":0},{"$f":"MIN(D215,F220)","v":3283296.1716},{"$f":"F215*C215/100","v":0},{"$f":"D215-F215","v":0},{"$f":"H215*C215/100","v":0}]
[null,"201-1,000 THERMS",{"$f":"E78","v":33.451000000000001},{"$f":"E32","v":8247668.8472199989},{"$f":"C216*D216/100","v":2758927.7060835618},{"$f":"MIN(F220-F215,D216)","v":8247668.8472199989},{"$f":"F216*C216/100","v":2758927.7060835618},{"$f":"D216-F216","v":0},{"$f":"H216*C216/100","v":0}]
[null,"1,000-10,000 THERMS",{"$f":"E79","v":24.364000000000001},{"$f":"E33","v":11206259.59857},{"$f":"C217*D217/100","v":2730293.0885955947},{"$f":"MIN(F220-F215-F216,D217)","v":360679.98118000198},{"$f":"F217*C217/100","v":87876.07061469568},{"$f":"D217-F217","v":10845579.617389999},{"$f":"H217*C217/100","v":2642417.0179808997}]
[null,"OVER 10,000 THERMS",{"$f":"E80","v":18.358000000000001},{"$f":"E34","v":3500647.9710199996},{"$f":"C218*D218/100","v":642648.9545198516},{"$f":"MIN(F220-F215-F216-F217,D218)","v":0},{"$f":"F218*C218/100","v":0},{"$f":"D218-F218","v":3500647.9710199996},{"$f":"H218*C218/100","v":642648.9545198516}]
[]
[null,"TOTAL",null,{"$f":"SUM(D215:D218)","v":26237872.588409998},{"$f":"SUM(E215:E218)","v":6131869.7491990086},{"$f":"F210","v":11891645},{"$f":"SUM(G215:G218)","v":2846803.7766982573},{"$f":"SUM(H215:H218)","v":14346227.588409999},{"$f":"SUM(I215:I218)","v":3285065.9725007513}]
[null,"AVERAGE RATE",null,null,{"$f":"E220/D220*100","v":23.370300806733955},null,{"$f":"G220/F220*100","v":23.939528775861181},null,{"$f":"I220/H220*100","v":22.898465483390794}]
[]
[]
[null,"(1) Base load per bill for Schedule 111 is multiplied by total billings from JDM-G-1"]
[null,{"$f":"\"636 X \"&TEXT(E26,\"#,##0\")&\" = \"&TEXT(F210,\"#,##0\")","v":"636 X 18,727 = 11,891,645"}]

{"sheet":"Rate Design","index":1,"n_rows":122,"n_cols":16,"rows_kept":122,"cut":false,"hidden":false,"merged":[]}
["PRESENT RATES",null,null,1,2,3,4,null,null,null,"Tiers - used for bill comparisons"]
[null,null,"TOTAL","SCH. 101","SCH. 111,112","SCH. 131,132","SCH. 146",null,"Range Name",null,"SCH. 101","SCH. 111,112","SCH. 131,132","SCH. 146"]
[null,"Base Tariff Rates"]
[1,"BASIC CHARGE",null,15,null,null,300]
[2,"MONTHLY MINIMUM",null,0,81.739999999999995]
[3,"BLOCK 1 PER THERM",null,33.371000000000002,0,20.379000000000001,12.231999999999999,null,null,null,9999999,200,9999999,9999999]
[4,"BLOCK 2 PER THERM",null,0,32.368000000000002,null,null,null,null,null,9999999,1000,9999999,9999999]
[5,"BLOCK 3 PER THERM",null,0,23.574999999999999,null,null,null,"Rates_Base_Present",null,9999999,10000,9999999,9999999]
[6,"BLOCK 4 PER THERM",null,0,17.763999999999999,null,null,null,null,null,9999999,9999999,9999999,9999999]
[7,"BLOCK 5 PER THERM",null,null,null,null,null,null,null,null,9999999,9999999,9999999,9999999]
[null,null,null,null,null,null,null,null,null,null,"1st block rate",{"$f":"((E5+(E6/100)*200)/2)","v":40.869999999999997}]
[null,"Billing Rates",null,{"$f":"IF(D13<>'Pres & Prop Rev'!D$5,#VALUE!,\"\")","v":""},{"$f":"IF(E13<>'Pres & Prop Rev'!E$5,#VALUE!,\"\")","v":""},{"$f":"IF(F13<>'Pres & Prop Rev'!F$5,#VALUE!,\"\")","v":""},{"$f":"IF(G13<>'Pres & Prop Rev'!G$5,#VALUE!,\"\")","v":""},null,null,null,"check",{"$f":"L6*L11/100-(L6*E6/100+E5)","v":0}]
[null,null,null,"SCHEDULE 101","SCH. 111&112","SCH. 131&132","SCHEDULE 146"]
[1,"BASIC CHARGE",null,{"$f":"D4","v":15},0,0,300]
[2,"MONTHLY MINIMUM",null,0,81.739999999999995,0,0]
[3,"BLOCK 1 PER THERM",null,{"$f":"D6+44.308+13.163-1.02-1.567+4.903","v":93.158000000000015},{"$f":"E6+44.308+13.163+0.381-0.811+2.626","v":59.667000000000002},{"$f":"F6+35.07-0.811+2.626","v":57.263999999999996},{"$f":"G6-0.365","v":11.866999999999999},null,null,null,{"$f":"K6","v":9999999},200,9999999,9999999]
[4,"BLOCK 2 PER THERM",null,null,{"$f":"E7+44.308+13.163+0.381-0.811+2.626","v":92.034999999999997},null,null,null,null,null,9999999,1000,9999999,9999999]
[5,"BLOCK 3 PER THERM",null,null,{"$f":"E8+44.308+13.163+0.381-0.811+2.626","v":83.24199999999999},null,null,null,"Rates_Billing_Present",null,9999999,10000,9999999,9999999]
[6,"BLOCK 4 PER THERM",null,null,{"$f":"E9+44.308+13.163+0.381-0.811+2.626","v":77.430999999999997},null,null,null,null,null,{"$f":"K9","v":9999999},9999999,9999999,9999999]
[7,"BLOCK 5 PER THERM",null,{"$f":"D10","v":0},null,null,null,null,null,null,9999999,9999999,9999999,9999999]
[null,null,null,null,null,null,null,null,null,null,"1st block rate",{"$f":"((E15+E16/100*200)/2)","v":100.53700000000001}]
["PROPOSED RATES",null,null,null,null,null,null,null,null,null,"check",{"$f":"L16*L21/100-(L16*E16/100+E15)","v":0}]
[]
[null,"Base Tariff Rates",null,{"$f":"IF(D25<>'Pres & Prop Rev'!D$5,#VALUE!,\"\")","v":""},{"$f":"IF(E25<>'Pres & Prop Rev'!E$5,#VALUE!,\"\")","v":""},{"$f":"IF(F25<>'Pres & Prop Rev'!F$5,#VALUE!,\"\")","v":""},{"$f":"IF(G25<>'Pres & Prop Rev'!G$5,#VALUE!,\"\")","v":""}]
[null,null,null,"SCHEDULE 101","SCH. 111&112","SCH. 131&132","SCHEDULE 146"]
[1,"BASIC CHARGE",null,{"$f":"IF(D4>0,ROUND(D63,2),0)","v":20},{"$f":"IF(E4>0,ROUND(E63,2),0)","v":0},{"$f":"IF(F4>0,ROUND(F63,2),0)","v":0},{"$f":"IF(G4>0,ROUND(G63,2),0)","v":300}]
[2,"MONTHLY MINIMUM",null,{"$f":"IF(D5>0,ROUND(D63,2),0)","v":0},{"$f":"IF(E5>0,ROUND(E63,2),0)","v":71.209999999999994},{"$f":"IF(F5>0,ROUND(F63,2),0)","v":0},{"$f":"IF(G5>0,ROUND(G63,2),0)","v":0}]
[2,"BLOCK 1 PER THERM",null,{"$f":"ROUND(D82,3)","v":25.605},{"$f":"ROUND(E82,3)","v":0},{"$f":"ROUND(F82,3)","v":20.379000000000001},{"$f":"ROUND(G82,3)","v":12.231999999999999},null,null,null,9999999,200,9999999,9999999]
[3,"BLOCK 2 PER THERM",null,{"$f":"ROUND(D83,3)","v":0},{"$f":"ROUND(E83,3)","v":33.451000000000001},0,0,null,null,null,9999999,1000,9999999,9999999]
[4,"BLOCK 3 PER THERM",null,0,{"$f":"ROUND(E84,3)","v":24.364000000000001},0,0,null,"Rates_Base_Proposed",null,9999999,10000,9999999,9999999]
[5,"BLOCK 4 PER THERM",null,{"$f":"ROUND(D85,3)","v":0},{"$f":"ROUND(E85,3)","v":18.358000000000001},0,0,null,null,null,9999999,9999999,9999999,9999999]
[6,"BLOCK 5 PER THERM",null,0,0,0,0,null,null,null,9999999,9999999,9999999,9999999]
[null,null,null,null,null,null,null,3.1059999999999999,null,null,"1st block rate",{"$f":"(E27+E28/100*200)/2","v":35.604999999999997},null,null,{"$f":"E27/L28+(E28/100)","v":0.35604999999999998}]
[null,"Billing Rates",null,{"$f":"D28/D6-1","v":-0.23271702975637532},{"$f":"IF(E35<>'Pres & Prop Rev'!E$5,#VALUE!,\"\")","v":""},{"$f":"IF(F35<>'Pres & Prop Rev'!F$5,#VALUE!,\"\")","v":""},{"$f":"IF(G35<>'Pres & Prop Rev'!G$5,#VALUE!,\"\")","v":""},3.7959999999999998,null,null,"check",{"$f":"L28*L33/100-(L28*E28/100+E27)","v":0}]
[null,null,null,"SCHEDULE 101","SCH. 111&112","SCH. 131&132","SCHEDULE 146",null,null,null,"Basic Charge Calc",{"$f":"E5+(D26-D4)+(((D28-D6)*192)/100)","v":71.829279999999997}]
[1,"BASIC CHARGE",null,{"$f":"D26","v":20},0,0,300]
[2,"MONTHLY MINIMUM",null,0,71.209999999999994,0,0]
[2,"BLOCK 1 PER THERM",null,{"$f":"D28+44.308+13.163-1.02-1.567+4.903","v":85.39200000000001},{"$f":"E28+44.308+13.163+0.381-0.811+2.626","v":59.667000000000002},{"$f":"F28+35.07-0.811+2.626","v":57.263999999999996},{"$f":"G28-0.365","v":11.866999999999999},null,null,null,{"$f":"K28","v":9999999},200,9999999,9999999]
[3,"BLOCK 2 PER THERM",null,null,{"$f":"E29+44.308+13.163+0.381-0.811+2.626","v":93.117999999999995},null,null,null,null,null,9999999,1000,9999999,9999999]
[4,"BLOCK 3 PER THERM",null,null,{"$f":"E30+44.308+13.163+0.381-0.811+2.626","v":84.030999999999992},null,null,null,"Rates_Billing_Proposed",null,9999999,10000,9999999,9999999]
[5,"BLOCK 4 PER THERM",null,null,{"$f":"E31+44.308+13.163+0.381-0.811+2.626","v":78.024999999999991},null,null,null,null,null,9999999,9999999,9999999,9999999]
[6,"BLOCK 5 PER THERM",null,{"$f":"D32","v":0},0,null,null,null,null,null,9999999,9999999,9999999,9999999]
[null,null,null,null,null,null,null,null,null,null,"1st block rate",{"$f":"(E37+E38/100*200)/2","v":95.271999999999991}]
[null,null,null,null,null,null,null,null,null,null,"check",{"$f":"L38*L43/100-(L38*E38/100+E37)","v":0}]
[]
[]
[" ","Proposed Rate Workup - from Pres & Prop Rev tab"]
[]
[null,"THERMS"]
[null,"BLOCK 1",{"$f":"SUM(D50:G50)","v":77232568.475549981},{"$f":"'Pres & Prop Rev'!D31","v":70027024.203949988},{"$f":"'Pres & Prop Rev'!E31","v":3283296.1716},{"$f":"'Pres & Prop Rev'!F31","v":0.1},{"$f":"'Pres & Prop Rev'!G31","v":3922248}]
[null,"BLOCK 2",8247668.8472199989,{"$f":"'Pres & Prop Rev'!D32","v":0},{"$f":"'Pres & Prop Rev'!E32","v":8247668.8472199989},{"$f":"'Pres & Prop Rev'!F32","v":0},{"$f":"'Pres & Prop Rev'!G32","v":0}]
[null,"BLOCK 3",11206259.59857,{"$f":"'Pres & Prop Rev'!D33","v":0},{"$f":"'Pres & Prop Rev'!E33","v":11206259.59857},{"$f":"'Pres & Prop Rev'!F33","v":0},{"$f":"'Pres & Prop Rev'!G33","v":0}]
[null,"BLOCK 4",3500647.9710199996,{"$f":"'Pres & Prop Rev'!D34","v":0},{"$f":"'Pres & Prop Rev'!E34","v":3500647.9710199996},{"$f":"'Pres & Prop Rev'!F34","v":0},{"$f":"'Pres & Prop Rev'!G34","v":0}]
[null,"BLOCK 5",0,{"$f":"'Pres & Prop Rev'!D35","v":0},{"$f":"'Pres & Prop Rev'!E35","v":0},{"$f":"'Pres & Prop Rev'!F35","v":0},{"$f":"'Pres & Prop Rev'!G35","v":0}]
[null,"ADJ. TO ACTUAL",0,{"$f":"'Pres & Prop Rev'!D41","v":0},{"$f":"'Pres & Prop Rev'!E41","v":0},{"$f":"'Pres & Prop Rev'!F41","v":0},{"$f":"'Pres & Prop Rev'!G41","v":0}]
[null,"WEATHER & U/B THERMS",-710273,{"$f":"'Pres & Prop Rev'!D44","v":-547518},{"$f":"'Pres & Prop Rev'!E44","v":-162755},{"$f":"'Pres & Prop Rev'!F44","v":0},{"$f":"'Pres & Prop Rev'!G44","v":0},"Proposed rates:"]
[null,"TOTAL PROFORMA THERMS",{"$f":"IF(ROUND(SUM(D57:G57),3)<>ROUND(SUM(C50:C56),3),#VALUE!,SUM(D57:G57))","v":99476871.892359972},{"$f":"SUM(D50:D56)","v":69479506.203949988},{"$f":"SUM(E50:E56)","v":26075117.588409998},{"$f":"SUM(F50:F56)","v":0.1},{"$f":"SUM(G50:G56)","v":3922248},"same as current"]
[null,"TOTAL BILLS",null,{"$f":"SUM('Pres & Prop Rev'!D48:D49)","v":1079689},{"$f":"SUM('Pres & Prop Rev'!E48:E49)","v":18727},{"$f":"SUM('Pres & Prop Rev'!F48:F49)","v":0},{"$f":"SUM('Pres & Prop Rev'!G48:G49)","v":72},"diff than current"]
[null,null,null,null,null,null,null,"Formulas to copy"]
[null,"Proposed Revenue",{"$f":"SUM(D60:G60)","v":47314000},{"$f":"ROR!D46","v":39384999.996765636},{"$f":"ROR!E46","v":7427999.9999999981},{"$f":"ROR!F46","v":3.2343644958031533E-3},{"$f":"ROR!G46","v":501000.00000000017},"FLOOR","CEILING","OTHER"]
[null,"Targeted Rate Increase",{"$f":"ROR!C47","v":6.3410200587643573E-5},{"$f":"ROR!D47","v":7.6176851496523312E-5},{"$f":"ROR!E47","v":-2.2204460492503131E-16},{"$f":"ROR!F47","v":0},{"$f":"ROR!G47","v":4.4408920985006262E-16}]
[null,"Present Basic/Min Charge",null,{"$f":"D4","v":15},{"$f":"E4+E5","v":81.739999999999995},{"$f":"F4+F5","v":0},{"$f":"G4","v":300}]
[null,"BASIC/MIN CHARGE",null,20,{"$f":"D63+(200*('Appendix F Pg 6'!R20))","v":71.210000000000008},null,300,{"$f":"FLOOR(H62*(1+H$61),$H64)","v":0},{"$f":"CEILING(I62*(1+I$61),$I64)","v":0},1.05]
[null,"% D in Basic Charge",null,{"$f":"IF(D62,D63/D62-1,0)","v":0.33333333333333326},{"$f":"IF(E62,E63/E62-1,0)","v":-0.12882309762662081},{"$f":"IF(F62,F63/F62-1,0)","v":0},{"$f":"IF(G62,G63/G62-1,0)","v":0},0.05,0.05]
[null,"Basic Charge Revenue",{"$f":"SUM(D65:G65)","v":22948929.670000002},{"$f":"D58*D63","v":21593780},{"$f":"E58*E63","v":1333549.6700000002},{"$f":"F58*F63","v":0},{"$f":"(G58*G63)+'Pres & Prop Rev'!G156","v":21600}]
[]
[null,"Present Block 1 Rate",null,{"$f":"D6","v":33.371000000000002},{"$f":"E6","v":0},{"$f":"F6","v":20.379000000000001},12.231999999999999]
[null,"Present Block 2 Rate",null,0,32.368000000000002,0,0]
[null,"Present Block 3 Rate",null,0,23.574999999999999,0,0]
[null,"Present Block 4 Rate",null,{"$f":"D9","v":0},17.763999999999999,0,0]
[null,"Present Block 5 Rate",null,0,0,0,0]
[]
[null,"1) Flat Rate Increase",null,1,1,1,1]
[null,"2) % Rate Increase",null,-0.23267432697166579,3.3449372992451175E-2,0,0]
[null,"Method --->",null,2,2,2,2]
[]
["Calculated","BLOCK 1 PER THERM",null,{"$f":"CHOOSE(D$75,D67+D$73,D67*(1+D$74))","v":25.606425034628543},{"$f":"CHOOSE(E$75,E67+E$73,E67*(1+E$74))","v":0},{"$f":"CHOOSE(F$75,F67+F$73,F67*(1+F$74))","v":20.379000000000001},{"$f":"CHOOSE(G$75,G67+G$73,G67*(1+G$74))","v":12.231999999999999}]
[null,"BLOCK 2 PER THERM",null,0,{"$f":"CHOOSE(E$75,E68+E$73,E68*(1+E$74+E76))","v":33.450689305019665},0,0]
[null,"BLOCK 3 PER THERM",null,0,{"$f":"CHOOSE(E$75,E69+E$73,E69*(1+E$74+E76))","v":24.363568968297038},0,0]
[null,"BLOCK 4 PER THERM",null,0,{"$f":"CHOOSE(E$75,E70+E$73,E70*(1+E$74))","v":18.358194661837903},0,0]
[null,"BLOCK 5 PER THERM",null,0,0,0,0]
["Input","BLOCK 1 PER THERM",null,{"$f":"D77-0.001","v":25.605425034628542},{"$f":"E67","v":0},{"$f":"F77","v":20.379000000000001},{"$f":"G77","v":12.231999999999999},null,null,null,null,{"$f":"D63+((200*D82)/100)","v":71.210850069257077},{"$f":"E63+((200*E82)/100)","v":71.210000000000008},{"$f":"L82-M82","v":8.5006925706920811E-4}]
[null,"BLOCK 2 PER THERM",null,{"$f":"D78","v":0},{"$f":"E78","v":33.450689305019665},{"$f":"F78","v":0},0]
[null,"BLOCK 3 PER THERM",null,0,{"$f":"E79","v":24.363568968297038},0,0]
[null,"BLOCK 4 PER THERM",null,0,{"$f":"E80","v":18.358194661837903},0,0]
[null,"BLOCK 5 PER THERM",null,0,0,0,{"$f":"G81","v":0}]
[null,"Blocks 1-5 Revenue",{"$f":"SUM(D87:G87)","v":24542289.218262602},{"$f":"SUMPRODUCT(D50:D54,D82:D86)/100","v":17930717.186523601},{"$f":"SUMPRODUCT(E50:E54,E82:E86)/100","v":6131802.6359999981},{"$f":"SUMPRODUCT(F50:F54,F82:F86)/100","v":2.0379000000000001E-2},{"$f":"SUMPRODUCT(G50:G54,G82:G86)/100","v":479769.37536000001}]
[null,"Adj. to Actual Revenue",{"$f":"SUM(D88:G88)","v":0},{"$f":"'Pres & Prop Rev'!D168","v":0},{"$f":"'Pres & Prop Rev'!E168","v":0},{"$f":"'Pres & Prop Rev'!F168","v":0},{"$f":"'Pres & Prop Rev'!G168","v":0}]
[null,"Weather & U/B Revenue",{"$f":"SUM(D89:G89)","v":-177581.75},{"$f":"'Pres & Prop Rev'!D190","v":-140191.99},{"$f":"'Pres & Prop Rev'!E190","v":-37389.760000000002},{"$f":"'Pres & Prop Rev'!F190","v":0},{"$f":"'Pres & Prop Rev'!G190","v":0}]
[]
[" ","Revenue Remaining",{"$f":"IF(ROUND(C60-C65-SUM(C87:C89),3)<>ROUND(SUM(D91:G91),3),#VALUE!,SUM(D91:G91))","v":362.86173739743128},{"$f":"D60-D65-SUM(D87:D89)","v":694.80024203285575},{"$f":"E60-E65-SUM(E87:E89)","v":37.453999999910593},{"$f":"F60-F65-SUM(F87:F89)","v":-1.7144635504196849E-2},{"$f":"G60-G65-SUM(G87:G89)","v":-369.37535999983083}]
[null,"Revenue Remaining - ¢/Th",{"$f":"C91/C57*100","v":3.6476995154217327E-4},{"$f":"D91/D57*100","v":1.0000074554262673E-3},{"$f":"E91/E57*100","v":1.4363885368079161E-4},{"$f":"F91/F57*100","v":-17.144635504196849},{"$f":"G91/G57*100","v":-9.4174402026549787E-3}]
[null,"check - < $4k is rounding",{"$f":"SUM(D93:G93)","v":230.51826260619686},{"$f":"D60-'Pres & Prop Rev'!D192-D91","v":297.6365236081183},{"$f":"E60-'Pres & Prop Rev'!E192-E91","v":-67.11400000192225},{"$f":"F60-'Pres & Prop Rev'!F192-F91","v":3.7900000000000086E-4},{"$f":"G60-'Pres & Prop Rev'!G192-G91","v":-4.6399999991990626E-3}]
[]
[null,"Proposed Target",{"$f":"SUM(D95:G95)","v":47314000},{"$f":"D60","v":39384999.996765636},{"$f":"E60","v":7427999.9999999981},{"$f":"F60","v":3.2343644958031533E-3},{"$f":"G60","v":501000.00000000017}]
[null,"Proposed Actual",{"$f":"'Pres & Prop Rev'!C192-SUM('Pres & Prop Rev'!H192:I192)","v":47313406.620000005},{"$f":"'Pres & Prop Rev'!D192","v":39384007.559999995},{"$f":"'Pres & Prop Rev'!E192","v":7428029.6600000001},{"$f":"'Pres & Prop Rev'!F192","v":0.02},{"$f":"'Pres & Prop Rev'!G192","v":501369.38}]
[null,null,{"$f":"SUM(D97:G97)","v":-593.3800000036282},{"$f":"D96-D95","v":-992.43676564097404},{"$f":"E96-E95","v":29.660000002011657},{"$f":"F96-F95","v":1.6765635504196848E-2},{"$f":"G96-G95","v":369.37999999983003}]
[null,"Rate D Check"]
[null,"Basic/Min Charge",{"$f":"SUM('Pres & Prop Rev'!C155:C156)/SUM('Pres & Prop Rev'!C106:C107)-1","v":0.29184957221558294},{"$f":"SUM('Pres & Prop Rev'!D155:D156)/SUM('Pres & Prop Rev'!D106:D107)-1","v":0.33333333333333326},{"$f":"SUM('Pres & Prop Rev'!E155:E156)/SUM('Pres & Prop Rev'!E106:E107)-1","v":-0.12882309762662103},{"$f":"SUM('Pres & Prop Rev'!F155:F156)/SUM('Pres & Prop Rev'!F106:F107)-1","v":{"$error":"#DIV/0!"}},{"$f":"SUM('Pres & Prop Rev'!G155:G156)/SUM('Pres & Prop Rev'!G106:G107)-1","v":0}]
[null,"Adj. to Actual Revenue",{"$f":"'Pres & Prop Rev'!C168/'Pres & Prop Rev'!C119-1","v":{"$error":"#DIV/0!"}},{"$f":"'Pres & Prop Rev'!D168/'Pres & Prop Rev'!D119-1","v":{"$error":"#DIV/0!"}},{"$f":"'Pres & Prop Rev'!E168/'Pres & Prop Rev'!E119-1","v":{"$error":"#DIV/0!"}},{"$f":"'Pres & Prop Rev'!F168/'Pres & Prop Rev'!F119-1","v":{"$error":"#DIV/0!"}},{"$f":"'Pres & Prop Rev'!G168/'Pres & Prop Rev'!G119-1","v":{"$error":"#DIV/0!"}}]
[null,"Weather & U/B Revenue",{"$f":"'Pres & Prop Rev'!C190/'Pres & Prop Rev'!C142-1","v":-0.18872205017849486},{"$f":"'Pres & Prop Rev'!D190/'Pres & Prop Rev'!D142-1","v":-0.23271698889559822},{"$f":"'Pres & Prop Rev'!E190/'Pres & Prop Rev'!E142-1","v":3.3461537929995622E-2},{"$f":"'Pres & Prop Rev'!F190/'Pres & Prop Rev'!F142-1","v":{"$error":"#DIV/0!"}},{"$f":"'Pres & Prop Rev'!G190/'Pres & Prop Rev'!G142-1","v":{"$error":"#DIV/0!"}}]
[null,"Block Therm Charges",{"$f":"SUM('Pres & Prop Rev'!C157:C161)/SUM('Pres & Prop Rev'!C108:C112)-1","v":-0.17578321829440502},{"$f":"SUM('Pres & Prop Rev'!D157:D161)/SUM('Pres & Prop Rev'!D108:D112)-1","v":-0.23271702974124386},{"$f":"SUM('Pres & Prop Rev'!E157:E161)/SUM('Pres & Prop Rev'!E108:E112)-1","v":3.3460684057033285E-2},{"$f":"SUM('Pres & Prop Rev'!F157:F161)/SUM('Pres & Prop Rev'!F108:F112)-1","v":0},{"$f":"SUM('Pres & Prop Rev'!G157:G161)/SUM('Pres & Prop Rev'!G108:G112)-1","v":0}]
[null,"Overall Revenue",{"$f":"'Pres & Prop Rev'!C192/'Pres & Prop Rev'!C193-1","v":5.8933919831583026E-5},{"$f":"'Pres & Prop Rev'!D192/'Pres & Prop Rev'!D193-1","v":6.7710746534332955E-5},{"$f":"'Pres & Prop Rev'!E192/'Pres & Prop Rev'!E193-1","v":1.7174432087818658E-5},{"$f":"'Pres & Prop Rev'!F192/'Pres & Prop Rev'!F193-1","v":0},{"$f":"'Pres & Prop Rev'!G192/'Pres & Prop Rev'!G193-1","v":0}]
[]
[null,"Avg. Usage",null,{"$f":"D57/D58","v":64.351406936580801},{"$f":"E57/E58","v":1392.380925316922},{"$f":"F57/F58","v":{"$error":"#DIV/0!"}},{"$f":"G57/G58","v":54475.666666666664}]
[null,"Bill Compare:",{"$f":"INDEX($D$2:$G$2,I106)","v":"SCH. 101"},null,null,{"$f":"INDEX($D$2:$G$2,J106)","v":"SCH. 111,112"},null,null,1,2]
[null,null,"Pres","Prop","% Incr","Pres","Prop","% Incr"]
[null,0,{"$f":"I$108+MIN($B108,M$109)*I$109/100+MAX(0,MIN($B108-M$109,M$110-M$109))*I$110/100+MAX(0,MIN($B108-M$110,M$111-M$110))*I$111/100+MAX(0,MIN($B108-M$111,M$112-M$111))*I$112/100+MAX(0,$B108-M$113)*I$113/100","v":15},{"$f":"J$108+MIN($B108,N$109)*J$109/100+MAX(0,MIN($B108-N$109,N$110-N$109))*J$110/100+MAX(0,MIN($B108-N$110,N$111-N$110))*J$111/100+MAX(0,MIN($B108-N$111,N$112-N$111))*J$112/100+MAX(0,$B108-N$113)*J$113/100","v":20},{"$f":"D108/C108-1","v":0.33333333333333326},{"$f":"K$108+MIN($B108,O$109)*K$109/100+MAX(0,MIN($B108-O$109,O$110-O$109))*K$110/100+MAX(0,MIN($B108-O$110,O$111-O$110))*K$111/100+MAX(0,MIN($B108-O$111,O$112-O$111))*K$112/100+MAX(0,E108-O$113)*K$113/100","v":81.739999999999995},{"$f":"L$108+MIN($B108,P$109)*L$109/100+MAX(0,MIN($B108-P$109,P$110-P$109))*L$110/100+MAX(0,MIN($B108-P$110,P$111-P$110))*L$111/100+MAX(0,MIN($B108-P$111,P$112-P$111))*L$112/100+MAX(0,$B108-P$113)*L$113/100","v":71.209999999999994},{"$f":"G108/F108-1","v":-0.12882309762662103},{"$f":"INDEX(CHOOSE(Base1_Billing2,$D$4:$G$4,$D$14:$G$14),$I$106)+INDEX(CHOOSE(Base1_Billing2,$D$5:$G$5,$D$15:$G$15),$I$106)","v":15},{"$f":"INDEX(CHOOSE(Base1_Billing2,$D$26:$G$26,$D$36:$G$36),$I$106)+INDEX(CHOOSE(Base1_Billing2,$D$27:$G$27,$D$37:$G$37),$I$106)","v":20},{"$f":"INDEX(CHOOSE(Base1_Billing2,$D$4:$G$4,$D$14:$G$14),$J$106)+INDEX(CHOOSE(Base1_Billing2,$D$5:$G$5,$D$15:$G$15),$J$106)","v":81.739999999999995},{"$f":"INDEX(CHOOSE(Base1_Billing2,$D$26:$G$26,$D$36:$G$36),$J$106)+INDEX(CHOOSE(Base1_Billing2,$D$27:$G$27,$D$37:$G$37),$J$106)","v":71.209999999999994}]
[null,61,35.356310000000001,35.619050000000001,{"$f":"D109/C109-1","v":7.4312053492007202E-3},81.739999999999995,71.209999999999994,{"$f":"G109/F109-1","v":-0.12882309762662103},{"$f":"INDEX(CHOOSE(Base1_Billing2,$D6:$G6,$D16:$G16),$I$106)","v":33.371000000000002},{"$f":"INDEX(CHOOSE(Base1_Billing2,$D28:$G28,$D38:$G38),$I$106)","v":25.605},{"$f":"INDEX(CHOOSE(Base1_Billing2,$D6:$G6,$D16:$G16),$J$106)","v":0},{"$f":"INDEX(CHOOSE(Base1_Billing2,$D28:$G28,$D38:$G38),$J$106)","v":0},{"$f":"INDEX($K6:$N6,$I$106)","v":9999999},{"$f":"INDEX($K28:$N28,$I$106)","v":9999999},{"$f":"INDEX($K6:$N6,$J$106)","v":200},{"$f":"INDEX($K28:$N28,$J$106)","v":200}]
[null,70,38.359700000000004,37.923500000000004,-1.1371308951842685E-2,81.739999999999995,71.209999999999994,-0.12882309762662103,{"$f":"INDEX(CHOOSE(Base1_Billing2,$D7:$G7,$D17:$G17),$I$106)","v":0},{"$f":"INDEX(CHOOSE(Base1_Billing2,$D29:$G29,$D39:$G39),$I$106)","v":0},{"$f":"INDEX(CHOOSE(Base1_Billing2,$D7:$G7,$D17:$G17),$J$106)","v":32.368000000000002},{"$f":"INDEX(CHOOSE(Base1_Billing2,$D29:$G29,$D39:$G39),$J$106)","v":33.451000000000001},{"$f":"INDEX($K7:$N7,$I$106)","v":9999999},{"$f":"INDEX($K29:$N29,$I$106)","v":9999999},{"$f":"INDEX($K7:$N7,$J$106)","v":1000},{"$f":"INDEX($K29:$N29,$J$106)","v":1000}]
[null,100,48.371000000000002,45.605000000000004,-5.7183022885613277E-2,81.739999999999995,71.209999999999994,-0.12882309762662103,{"$f":"INDEX(CHOOSE(Base1_Billing2,$D8:$G8,$D18:$G18),$I$106)","v":0},{"$f":"INDEX(CHOOSE(Base1_Billing2,$D30:$G30,$D40:$G40),$I$106)","v":0},{"$f":"INDEX(CHOOSE(Base1_Billing2,$D8:$G8,$D18:$G18),$J$106)","v":23.574999999999999},{"$f":"INDEX(CHOOSE(Base1_Billing2,$D30:$G30,$D40:$G40),$J$106)","v":24.364000000000001},{"$f":"INDEX($K8:$N8,$I$106)","v":9999999},{"$f":"INDEX($K30:$N30,$I$106)","v":9999999},{"$f":"INDEX($K8:$N8,$J$106)","v":10000},{"$f":"INDEX($K30:$N30,$J$106)","v":10000}]
[null,200,81.742000000000004,71.210000000000008,-0.12884441290890847,81.739999999999995,71.209999999999994,-0.12882309762662103,{"$f":"INDEX(CHOOSE(Base1_Billing2,$D9:$G9,$D19:$G19),$I$106)","v":0},{"$f":"INDEX(CHOOSE(Base1_Billing2,$D31:$G31,$D41:$G41),$I$106)","v":0},{"$f":"INDEX(CHOOSE(Base1_Billing2,$D9:$G9,$D19:$G19),$J$106)","v":17.763999999999999},{"$f":"INDEX(CHOOSE(Base1_Billing2,$D31:$G31,$D41:$G41),$J$106)","v":18.358000000000001},{"$f":"INDEX($K9:$N9,$I$106)","v":9999999},{"$f":"INDEX($K31:$N31,$I$106)","v":9999999},{"$f":"INDEX($K9:$N9,$J$106)","v":9999999},{"$f":"INDEX($K31:$N31,$J$106)","v":9999999}]
[null,300,115.11300000000001,96.814999999999998,-0.15895685109414237,114.108,104.661,-8.2789988432011796E-2,{"$f":"INDEX(CHOOSE(Base1_Billing2,$D10:$G10,$D20:$G20),$I$106)","v":0},{"$f":"INDEX(CHOOSE(Base1_Billing2,$D32:$G32,$D42:$G42),$I$106)","v":0},{"$f":"INDEX(CHOOSE(Base1_Billing2,$D10:$G10,$D20:$G20),$J$106)","v":0},{"$f":"INDEX(CHOOSE(Base1_Billing2,$D32:$G32,$D42:$G42),$J$106)","v":0},{"$f":"INDEX($K10:$N10,$I$106)","v":9999999},{"$f":"INDEX($K32:$N32,$I$106)","v":9999999},{"$f":"INDEX($K10:$N10,$J$106)","v":9999999},{"$f":"INDEX($K32:$N32,$J$106)","v":9999999}]
[null,400,148.48400000000001,122.42,-0.17553406427628571,146.476,138.11199999999999,-5.7101504683361171E-2]
[null,500,181.85499999999999,148.02500000000001,-0.18602732946578315,178.84399999999999,171.56299999999999,-4.0711458030462389E-2]
[null,1000,348.71,276.05,-0.20836798485847829,340.68400000000003,338.81799999999998,-5.4772164234306864E-3]
[null,2000,682.42,532.1,-0.22027490401805327,576.43399999999997,582.45799999999997,1.045045920261467E-2]
[null,3000,1016.13,788.15,-0.22436105616407354,812.18399999999997,826.09799999999996,1.7131585946041694E-2]
[null,4000,1349.84,1044.2,-0.22642683577312861,1047.934,1069.7379999999998,2.08066538541547E-2]
[null,5000,1683.55,1300.25,-0.22767366576579251,1283.684,1313.3779999999999,2.3131861112236418E-2]
[null,10000,3352.1,2580.5,-0.23018406372124933,2462.4340000000002,2531.5780000000004,2.8079534314422228E-2]
[null,20000,6689.2,5141,-0.23144770675118098,4238.8340000000007,4367.3780000000006,3.032532059523918E-2]

{"sheet":"Appendix F Pg 4","index":2,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[4,0,4,11],[0,21,2,22],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11]]}
["AVISTA UTILITIES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This worksheet pulls data from 'Pres & Prop Rev' tab."]
["IDAHO GAS, CASE NO. AVU-G-23-01"]
["PROPOSED INCREASE BY SERVICE SCHEDULE"]
["12 MONTHS ENDED JUNE 30, 2022"]
["(000s of Dollars)"]
[]
["Effective September 1, 2023"]
[null,null,null,"Base Tariff",null,"Base Tariff","Base","Total Billed",null,"Sch 176","Total Billed","Percent ",null,"Percent "]
[null,null,null,"Distribution Revenue","Proposed","Distribution Revenue","Tariff","Revenue","Total ","Tax","Revenue"," Increase on",null," Increase on"]
["Line","Type of","Schedule","Under Present","General","Under Proposed","Percent","at Present","General","Rate","at Proposed","Billed GRC",null,"Billed GRC"]
["No.","Service","Number","Rates (1)","Increase","Rates","Increase","Rates (2)","Increase","Credit","Rates (2)","Revenue",null,"Revenue"]
[null,"(a)","(b)","(c)","(d)","(e)","(f)","(g)","(h)","(i)","(i)","(j)",null,"(k)"]
[]
[1,"General Service","101",38129.500520000001,1251.9404999999999,39381.741020000001,3.2833907681096473E-2,79669.212899999984,1251.9404999999999,0,80921.153399999981,1.6E-2,null,1.6E-2]
[2,"Large General Service","111/112",7427.8401399999993,0.26195000000018626,7427.9020899999996,3.5265971677223826E-5,22929.080559999999,0.26195000000018626,0,22929.342509999999,0,null,1.1424356912817541E-5]
[3,"Interruptible Service ","131/132",2.0000000000000002E-5,0,2.0000000000000002E-5,0,5.9999999999999995E-5,0,0,5.9999999999999995E-5,0,null,0]
[4,"Transportation Service","146",501.36937999999998,0,501.46938,0,487.05316999999997,0.1,0,487.15316999999999,0,null,0]
[5,"Special Contracts","148",100.28444,0,100.28444,0,100.28444,0,0,100.28444,0,null,0]
[6,"Total",null,{"$f":"SUM(D14:D18)","v":46158.994500000001},{"$f":"SUM(E14:E18)","v":1252.2024500000002},47410.996950000001,2.7123694169724603E-2,{"$f":"SUM(H14:H18)","v":103185.63112999999},{"$f":"SUM(I14:I18)","v":1252.3024500000001},0,{"$f":"SUM(K14:K18)","v":104437.93358},1.2E-2,null,1.2126797198954726E-2]
[]
[]
["Effective September 1, 2024",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sch 197",null,"Sch 197"]
[null,null,null,"Base Tariff",null,"Base Tariff","Base","Total Billed",null,"Sch 176","Total Billed","Percent ",null,"Percent ","Total","Percent ","Total","Percent ","Total Billed","Percent ","Percent "]
[null,null,null,"Distribution Revenue","Proposed","Distribution Revenue","Tariff","Revenue","Total ","Tax","Revenue"," Increase on",null," Increase on","Sch 197 - 2014"," Increase on","Sch 197 - 2014"," Increase on","Revenue"," Increase","Total Increase"]
["Line","Type of","Schedule","Under Present","General","Under Proposed","Percent","at Present","General","Rate","at Proposed","Billed GRC",null,"Billed GRC","Earnings/DSM","Billed GRC","Earnings","Billed GRC","at Proposed","on Billed","on Billed"]
["No.","Service","Number","Rates (1)","Increase","Rates","Increase","Rates (2)","Increase","Credit","Rates (2)","Revenue",null,"Revenue","Rebate Expiration (2)","Revenue","Rebate","Revenue","Rates (2)","Revenue","Revenue (2)"]
[null,"(a)","(b)","(c)","(d)","(e)","(f)","(g)","(h)","(i)","(i)","(j)",null,"(k)","(j)","(k)","(l)","(m)","(n)","(o)","(o)"]
[]
[1,"General Service","101",{"$f":"'Pres & Prop Rev'!$D$145/1000","v":39381.34102},{"$f":"'Pres & Prop Rev'!$D$195/1000+0.2","v":2.8665399999916557},{"$f":"'Pres & Prop Rev'!$D$192/1000+0.4","v":39384.40756},{"$f":"E29/D29","v":7.2789293755534367E-5},82439.975399999981,{"$f":"E29","v":2.8665399999916557},{"$f":"'Sch 177'!E12/1000","v":0},{"$f":"+I29+H29+J29","v":82442.841939999969},{"$f":"ROUND((I29+J29)/H29,3)","v":0},null,{"$f":"ROUND(E29/H29,3)","v":0},0,{"$f":"ROUND(O29/H29,3)","v":0},0,{"$f":"ROUND(Q29/H29,3)","v":0},{"$f":"H29+I29+O29+Q29","v":82442.841939999969},{"$f":"N29+P29+R29","v":0},{"$f":"(I29+O29+#REF!+P29+#REF!)/H29","v":{"$error":"#REF!"}},null,null,{"$f":"120/K29","v":1.4555538986311665E-3}]
[2,"Large General Service","111/112",{"$f":"'Pres & Prop Rev'!$E$145/1000","v":7427.9020899999996},{"$f":"'Pres & Prop Rev'!$E$195/1000","v":0.12757000000029803},{"$f":"'Pres & Prop Rev'!$E$192/1000","v":7428.0296600000001},{"$f":"E30/D30","v":1.7174432087903037E-5},22928.88276,{"$f":"E30","v":0.12757000000029803},{"$f":"'Sch 177'!E13/1000","v":0},{"$f":"+I30+H30+J30","v":22929.010330000001},{"$f":"ROUND((I30+J30)/H30,3)","v":0},null,{"$f":"E30/H30","v":5.5637250770389491E-6},0,{"$f":"O30/H30","v":0},0,0,{"$f":"H30+I30+O30+Q30","v":22929.010330000001},5.5637250770389491E-6,{"$f":"(I30+O30+#REF!+P30+#REF!)/H30","v":{"$error":"#REF!"}}]
[3,"Interruptible Service ","131/132",{"$f":"'Pres & Prop Rev'!$F$145/1000","v":2.0000000000000002E-5},{"$f":"'Pres & Prop Rev'!$F$195/1000","v":0},{"$f":"'Pres & Prop Rev'!$F$192/1000","v":2.0000000000000002E-5},0,5.9999999999999995E-5,{"$f":"E31","v":0},0,5.9999999999999995E-5,0,null,{"$f":"E31/H31","v":0},0,{"$f":"O31/H31","v":0},0,0,{"$f":"H31+I31+O31+Q31","v":5.9999999999999995E-5},0,{"$f":"(I31+O31+#REF!+P31+#REF!)/H31","v":{"$error":"#REF!"}}]
[4,"Transportation Service","146",{"$f":"'Pres & Prop Rev'!$G$145/1000","v":501.36937999999998},{"$f":"'Pres & Prop Rev'!$G$195/1000","v":0},{"$f":"'Pres & Prop Rev'!$G$192/1000+0.1","v":501.46938},0,487.15316999999999,{"$f":"E32+0.1","v":0.1},{"$f":"'Sch 177'!E15/1000","v":0},487.25317000000001,{"$f":"ROUND((I32+J32)/H32,3)","v":0},null,{"$f":"E32/H32","v":0},0,{"$f":"O32/H32","v":0},0,0,{"$f":"H32+I32+O32+Q32","v":487.25317000000001},0,{"$f":"(I32+O32+#REF!+P32+#REF!)/H32","v":{"$error":"#REF!"}}]
[5,"Special Contracts","148",{"$f":"SUM('Pres & Prop Rev'!$H$145:$I$145)/1000","v":100.28444},{"$f":"SUM('Pres & Prop Rev'!$H$195:$I$195)/1000","v":0},{"$f":"SUM('Pres & Prop Rev'!$H$192:$I$192)/1000","v":100.28444},0,100.28444,{"$f":"E33","v":0},0,100.28444,0,null,{"$f":"E33/H33","v":0},0,{"$f":"O33/H33","v":0},0,0,{"$f":"H33+I33+O33+Q33","v":100.28444},0,{"$f":"(I33+O33+#REF!+P33+#REF!)/H33","v":{"$error":"#REF!"}}]
[6,"Total",null,{"$f":"'Pres & Prop Rev'!$C$145/1000","v":47410.896950000002},{"$f":"'Pres & Prop Rev'!$C$195/1000+0.1","v":2.8941099999919535},{"$f":"'Pres & Prop Rev'!$C$192/1000+0.1","v":47413.791060000003},6.1043139577049346E-5,{"$f":"SUM(H29:H33)","v":105956.29582999999},{"$f":"SUM(I29:I33)","v":3.0941099999919537},{"$f":"SUM(J29:J33)","v":0},{"$f":"+I34+H34+J34","v":105959.38993999998},0,null,{"$f":"E34/H34","v":2.7314186262564007E-5},{"$f":"SUM(O29:O33)","v":0},{"$f":"O34/H34","v":0},{"$f":"SUM(Q29:Q33)+0.4","v":0.4},0,{"$f":"SUM(S29:S33)","v":105959.38993999998},2.7314186262564007E-5,{"$f":"(I34+O34+#REF!+P34+#REF!)/H34","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"ROUND(D34-SUM(D29:D33),0)","v":0},{"$f":"ROUND(E34-SUM(E29:E33),0)","v":0}]
[]
["(1) Excludes Schedule 150 - Purchased Gas Cost Adjustment, Schedule 155 - Gas Rate Adjustment, Schedule 175 - Decoupling & Schedule 191 - DSM"]
["(2) Includes Schedule 150 - Purchased Gas Cost Adjustment, Schedule 155 - Gas Rate Adjustment, Schedule 175 - Decoupling, & Schedule 191 - DSM"]
[]
[]
[]
[null,null,null,{"$f":"SUM(ROUND(D29:D33,0))","v":47410},{"$f":"SUM(ROUND(E29:E33,0))","v":3},{"$f":"SUM(ROUND(F29:F33,0))","v":47413}]
[null,null,null,{"$f":"ROUND(D34,0)-D42","v":1},{"$f":"ROUND(E34,0)-E42","v":0},{"$f":"ROUND(F34,0)-F42","v":1}]
[]
[null,null,null,null,null,null,null,"Sch 155 Adj to Billed Revenue"]
[null,null,null,null,null,null,"Schedule ","Therms","Rate ",null,"Adjustment"]
[null,null,null,null,null,null,112,{"$f":"ROUND('Rev Runs CY'!O22,0)","v":431644},0.13163,null,{"$f":"(H47*-I47)/1000","v":-56.817299719999994}]

{"sheet":"COS","index":3,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":true,"merged":[[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,10],[4,0,4,10]]}
["AVISTA UTILITIES",null,null,null,null,null,null,null,null,null,null,"This worksheet pulls data from 'ROR' tab."]
["IDAHO GAS, CASE NO. AVU-G-23-01"]
["PRESENT & PROPOSED RATES OF RETURN BY RATE SCHEDULE"]
["12 MONTHS ENDED JUNE 30, 2022"]
[]
["Not Used"]
[]
[null,null,null,"Present Rates",null,null,"Base",null,"Proposed Rates"]
[null,null,null,"Present","Present",null,"Tariff",null,"Proposed","Proposed"]
["Line","Type of","Sch.","Rate of","Relative ",null,"Proposed ",null,"Rate of","Relative"]
["No.","Service","Number","Return","ROR",null,"Increase",null,"Return","ROR"]
[null,"(a)","(b)","(c)","(d)",null,"(e)",null,"(f)","(g)"]
[]
[1,"General Service","101",{"$f":"INDEX(ROR!$C$20:$G$20,$A14+1)","v":6.6906270110670643E-2},{"$f":"INDEX(ROR!$C$21:$G$21,$A14+1)","v":0.9357364368207759},null,{"$f":"INDEX(ROR!$C$47:$G$47,$A14+1)","v":7.6176851496523312E-5},null,{"$f":"INDEX(ROR!$C$38:$G$38,$A14+1)","v":6.6648359811613628E-2},{"$f":"INDEX(ROR!$C$37:$G$37,$A14+1)","v":0.9320031491467976}]
[2,"Large General Service","111/112",{"$f":"INDEX(ROR!$C$20:$G$20,$A15+1)","v":9.2014494565185095E-2},{"$f":"INDEX(ROR!$C$21:$G$21,$A15+1)","v":1.2868945636615148},null,{"$f":"INDEX(ROR!$C$47:$G$47,$A15+1)","v":-2.2204460492503131E-16},null,{"$f":"INDEX(ROR!$C$38:$G$38,$A15+1)","v":9.3273207985772932E-2},{"$f":"INDEX(ROR!$C$37:$G$37,$A15+1)","v":1.3043220241200397}]
[3,"Interruptible Service ","131/132",{"$f":"INDEX(ROR!$C$20:$G$20,$A16+1)","v":-0.14709339623973702},0,null,{"$f":"INDEX(ROR!$C$47:$G$47,$A16+1)","v":0},null,{"$f":"INDEX(ROR!$C$38:$G$38,$A16+1)","v":7.1510874048684156E-2},{"$f":"INDEX(ROR!$C$37:$G$37,$A16+1)","v":1}]
[4,"Transportation Service","146",{"$f":"INDEX(ROR!$C$20:$G$20,$A17+1)","v":0.11689869544865636},{"$f":"INDEX(ROR!$C$21:$G$21,$A17+1)","v":1.634919545913786},null,{"$f":"INDEX(ROR!$C$47:$G$47,$A17+1)","v":4.4408920985006262E-16},null,{"$f":"INDEX(ROR!$C$38:$G$38,$A17+1)","v":0.11864023309675016},{"$f":"INDEX(ROR!$C$37:$G$37,$A17+1)","v":1.6590516431945812}]
[5,"Total",null,{"$f":"INDEX(ROR!$C$20:$G$20,1)","v":7.1501191444450912E-2},{"$f":"INDEX(ROR!$C$21:$G$21,1)","v":1},null,{"$f":"INDEX(ROR!$C$47:$G$47,1)","v":6.3410200587643573E-5},null,{"$f":"INDEX(ROR!$C$38:$G$38,1)","v":7.1510874048684142E-2},{"$f":"INDEX(ROR!$C$37:$G$37,1)","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["(1) Includes Schedule 150/156 - Purchased Gas Cost Adjustment"]
[]
["(2) Includes Schedule 155 - Gas Rate Adjustment, Schedule 191 - Energy Efficiency Rider Adjustment and Schedule 199 - Deferred State Income Tax Adjustment"]

{"sheet":"Appendix F Pg 6","index":4,"n_rows":42,"n_cols":41,"rows_kept":42,"cut":false,"hidden":false,"merged":[[44,0,45,17],[0,0,0,17],[1,0,1,17],[2,0,2,17],[3,0,3,17],[9,0,9,17],[41,0,42,17]]}
["AVISTA UTILITIES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This worksheet uses Base & Billing rates from 'Rate Design' tab."]
["IDAHO GAS, CASE NO. AVU-G-23-01"]
["PRESENT AND PROPOSED RATE COMPONENTS BY SCHEDULE"]
[]
[]
[]
[]
[]
[]
["Effective September 1, 2024"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sch 197 - 2014",null,null,null,"Proposed  "]
[null,null,null,"Present Base",null,null,"Present",null,null,"General ",null,"Proposed",null,"Earnings Test","Schedule 172","Schedule 177","Proposed "," Base"]
[null,null,null,"Distribution ","Present","Revised","Billing","Present ",null,"Rate ","Sch. 191","PGA-Gas Cost",null,"Rebate","Tax reform","Depreciation","Billing ","Distribution"]
[null,"Type of Service",null,"Rate","Schedule 172","Base Rates","Rate Adj.(1)","Billing Rate",null,"Inc/(Decr)","Change","Rate","Open","Credit (2)","Change","Credit","Rate","Rate",null,"Base","Bill",null,null,null,null,null,null,"Sch 175","Sch 150","Sch 155","Sch 191","Sch 176"]
[null,"(a)",null,"(b)","(c)","(d)","(e)","(f)",null,"(g)","(f)","(f)","(f)","(g)","(h)","(h)","(h)","(i)",null,"Check","Check",null,null,null,null,null,null,"Decoupl","PGA","PGA","PP Rider","Tax Credit"]
["General Service - Schedule 101",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base"]
["Basic Charge",null,null,{"$f":"'Rate Design'!D4","v":15},null,null,{"$f":"H18-D18","v":0},{"$f":"'Rate Design'!D14","v":15},null,{"$f":"IF(ROUND(Q18-H18,5)<>ROUND(R18-D18,5),#VALUE!,R18-D18)","v":5},null,null,null,null,null,null,{"$f":"'Rate Design'!D36","v":20},{"$f":"'Rate Design'!D26","v":20},{"$f":"R18/D18-1","v":0.33333333333333326}]
["Usage Charge:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"check",null,"check","check",null,"Schedule 172 Rate"]
["All therms",null,null,{"$f":"'Rate Design'!D6/100-AO20","v":0.33371000000000001},0,{"$f":"D20+E20","v":0.33371000000000001},{"$f":"H20-F20","v":0.59787000000000012},{"$f":"'Rate Design'!D16/100","v":0.93158000000000019},null,{"$f":"(R20-D20)","v":-7.7660000000000007E-2},0,0,0,0,{"$f":"-E20","v":0},{"$f":"'Sch 177'!G12","v":0},{"$f":"H20+J20+O20+P20","v":0.85392000000000023},{"$f":"'Rate Design'!D28/100","v":0.25605},{"$f":"R20/D20-1","v":-0.23271702975637532},{"$f":"D20+J20-R20","v":0},{"$f":"H20+J20+M20+N20-Q20+O20+P20","v":0},{"$f":"D18+(200*D20)","v":81.742000000000004},{"$f":"H18+(200*H20)","v":201.31600000000003},{"$f":"J18+(J20*200)","v":-10.532000000000002},{"$f":"Q18+(200*Q20)","v":190.78400000000005},{"$f":"R18+(200*R20)","v":71.210000000000008},null,-7.8300000000000002E-3,0.25287999999999999,-3.7539999999999997E-2,1.8180000000000002E-2,-1.567E-2,{"$f":"AB20+AC20+AD20+AE20+AF20","v":0.21002000000000001},null,{"$f":"Q20-H20","v":-7.7659999999999951E-2},{"$f":"ROUND(AI20-K20-J20,5)","v":0},null,{"$f":"H20+J20+K20-Q20","v":0},{"$f":"R20-J20-D20","v":0},null,0]
[]
["Large General Service - Schedule 111"]
["Usage Charge:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(R29/200+R30)-R24","v":0}]
[{"$f":"\"First \"&TEXT('Rate Design'!L6,\"#,##0\")&\" therms\"","v":"First 200 therms"},null,null,{"$f":"'Rate Design'!L11/100","v":0.40869999999999995},0,{"$f":"D24+E24","v":0.40869999999999995},{"$f":"H24-F24","v":0.59667000000000014},{"$f":"'Rate Design'!L21/100","v":1.0053700000000001},null,{"$f":"(R24-D24)","v":-5.2649999999999975E-2},0,{"$f":"$L$20","v":0},{"$f":"M20","v":0},{"$f":"$N$20","v":0},{"$f":"-E24","v":0},{"$f":"'Sch 177'!G13","v":0},{"$f":"H24+J24+O24+P24","v":0.95272000000000012},{"$f":"'Rate Design'!L33/100","v":0.35604999999999998},{"$f":"R24/D24-1","v":-0.12882309762662092},{"$f":"D24+J24-R24","v":0},{"$f":"H24+J24+M24+N24-Q24+O24+P24","v":0},{"$f":"D24*200","v":81.739999999999995},{"$f":"H24*200","v":201.07400000000001},{"$f":"J24*200","v":-10.529999999999994},{"$f":"Q24*200","v":190.54400000000001},{"$f":"R24*200","v":71.209999999999994},null,-6.8700000000000002E-3,{"$f":"AC20","v":0.25287999999999999},{"$f":"AD20","v":-3.7539999999999997E-2},9.7800000000000005E-3,-8.1099999999999992E-3,{"$f":"AB24+AC24+AD24+AE24+AF24","v":0.21014000000000002},null,{"$f":"Q24-H24","v":-5.2649999999999975E-2},{"$f":"ROUND(AI24-K24-J24,5)","v":0},null,{"$f":"H24+J24+K24-Q24","v":0},{"$f":"R24-J24-D24","v":0},null,0]
[{"$f":"TEXT('Rate Design'!L6,\"#,##0\")&\" - \"&TEXT('Rate Design'!L7,\"#,##0\")&\" therms\"","v":"200 - 1,000 therms"},null,null,{"$f":"'Rate Design'!E7/100-AO25","v":0.32368000000000002},0,{"$f":"D25+E25","v":0.32368000000000002},{"$f":"H25-F25","v":0.59667000000000003},{"$f":"'Rate Design'!E17/100","v":0.92035},null,{"$f":"(R25-D25)","v":1.0830000000000006E-2},{"$f":"K24","v":0},{"$f":"$L$20","v":0},{"$f":"M20","v":0},{"$f":"$N$20","v":0},{"$f":"-E25","v":0},{"$f":"P24","v":0},{"$f":"H25+J25+O25+P25","v":0.93118000000000001},{"$f":"'Rate Design'!E29/100","v":0.33451000000000003},{"$f":"R25/D25-1","v":3.3458971824023687E-2},{"$f":"D25+J25-R25","v":0},{"$f":"H25+J25+M25+N25-Q25+O25+P25","v":0},null,null,null,null,null,null,{"$f":"AB24","v":-6.8700000000000002E-3},{"$f":"AC$24","v":0.25287999999999999},-3.7539999999999997E-2,9.7800000000000005E-3,-8.1099999999999992E-3,0.21014000000000002,null,{"$f":"Q25-H25","v":1.0830000000000006E-2},{"$f":"ROUND(AI25-K25-J25,5)","v":0},null,{"$f":"H25+J25+K25-Q25","v":0},{"$f":"R25-J25-D25","v":0},null,0]
[{"$f":"TEXT('Rate Design'!L7,\"#,##0\")&\" - \"&TEXT(10000,\"#,##0\")&\" therms\"","v":"1,000 - 10,000 therms"},null,null,{"$f":"'Rate Design'!E8/100-AO26","v":0.23574999999999999},0,{"$f":"D26+E26","v":0.23574999999999999},{"$f":"H26-F26","v":0.59666999999999992},{"$f":"'Rate Design'!E18/100","v":0.83241999999999994},null,{"$f":"(R26-D26)","v":7.8900000000000081E-3},{"$f":"K25","v":0},{"$f":"$L$20","v":0},{"$f":"M20","v":0},{"$f":"$N$20","v":0},{"$f":"-E26","v":0},{"$f":"P24","v":0},0.84030999999999989,{"$f":"'Rate Design'!E30/100","v":0.24364},{"$f":"R26/D26-1","v":3.3467656415694602E-2},{"$f":"D26+J26-R26","v":0},0,null,null,null,null,null,null,{"$f":"AB24","v":-6.8700000000000002E-3},0.25287999999999999,-3.7539999999999997E-2,9.7800000000000005E-3,-8.1099999999999992E-3,0.21014000000000002,null,{"$f":"Q26-H26","v":7.8899999999999526E-3},{"$f":"ROUND(AI26-K26-J26,5)","v":0},null,{"$f":"H26+J26+K26-Q26","v":0},{"$f":"R26-J26-D26","v":0},null,0]
[{"$f":"\"All over \"&TEXT(10000,\"#,##0\")&\" therms\"","v":"All over 10,000 therms"},null,null,{"$f":"'Rate Design'!E9/100-AO27","v":0.17763999999999999},0,{"$f":"D27+E27","v":0.17763999999999999},{"$f":"H27-F27","v":0.59666999999999992},{"$f":"'Rate Design'!E19/100","v":0.77430999999999994},null,{"$f":"(R27-D27)","v":5.9400000000000008E-3},{"$f":"K26","v":0},{"$f":"$L$20","v":0},{"$f":"M20","v":0},{"$f":"$N$20","v":0},{"$f":"-E27","v":0},{"$f":"P24","v":0},0.78024999999999989,{"$f":"'Rate Design'!E31/100","v":0.18357999999999999},{"$f":"R27/D27-1","v":3.3438414771447933E-2},{"$f":"D27+J27-R27","v":0},0,null,null,null,null,null,null,{"$f":"AB24","v":-6.8700000000000002E-3},0.25287999999999999,-3.7539999999999997E-2,9.7800000000000005E-3,-8.1099999999999992E-3,0.21014000000000002,null,{"$f":"Q27-H27","v":5.9399999999999453E-3},{"$f":"ROUND(AI27-K27-J27,5)","v":0},null,{"$f":"H27+J27+K27-Q27","v":0},{"$f":"R27-J27-D27","v":0},null,0]
["Minimum Charge:"]
["per month",null,null,{"$f":"'Rate Design'!E5","v":81.739999999999995},null,null,{"$f":"H29-D29","v":0},{"$f":"'Rate Design'!E15","v":81.739999999999995},null,{"$f":"(R29-D29)","v":-10.530000000000001},null,null,null,null,null,null,{"$f":"'Rate Design'!E37","v":71.209999999999994},{"$f":"'Rate Design'!E27","v":71.209999999999994},{"$f":"R29/D29-1","v":-0.12882309762662103}]
["per therm",null,null,{"$f":"'Rate Design'!E6/100","v":0},0,{"$f":"D30+E30","v":0},{"$f":"H30-F30","v":0.59667000000000003},{"$f":"'Rate Design'!E16/100","v":0.59667000000000003},null,{"$f":"(R30-D30)-L30","v":0},{"$f":"K24","v":0},{"$f":"L20","v":0},{"$f":"M20","v":0},{"$f":"$N$20","v":0},{"$f":"-E30","v":0},{"$f":"P24","v":0},{"$f":"H30+J30+O30+P30","v":0.59667000000000003},{"$f":"'Rate Design'!E28/100","v":0},{"$f":"R30/D30-1","v":{"$error":"#DIV/0!"}},{"$f":"D30+J30-R30","v":0},{"$f":"H30+J30+O30+M30+N30-Q30","v":0},{"$f":"$D29+D30*200","v":81.739999999999995},{"$f":"$H29+H30*200","v":201.07400000000001},{"$f":"$J29+J30*200","v":-10.530000000000001},{"$f":"$Q29+Q30*200","v":190.54399999999998},{"$f":"$R29+R30*200","v":71.209999999999994},null,{"$f":"AB24","v":-6.8700000000000002E-3},{"$f":"AC$24","v":0.25287999999999999},{"$f":"AD$24","v":-3.7539999999999997E-2},{"$f":"AE$24","v":9.7800000000000005E-3},{"$f":"AF$24","v":-8.1099999999999992E-3},{"$f":"AB30+AC30+AD30+AE30+AF30","v":0.21014000000000002},null,{"$f":"Q30-H30","v":0},{"$f":"ROUND(AI30-K30-J30,5)","v":0},null,{"$f":"H30+J30+K30-Q30","v":0},{"$f":"R30-J30-D30","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V24-V30","v":0},{"$f":"W24-W30","v":0},{"$f":"X24-X30","v":0},{"$f":"Y24-Y30","v":0},{"$f":"Z24-Z30","v":0}]
["Interruptible Service - Schedule 131"]
["Usage Charge:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ann. Min. calc",null,"Margin Rate",null,{"$f":"D34","v":0.20379000000000003}]
["All Therms",null,null,{"$f":"'Rate Design'!F6/100-AO34","v":0.20379000000000003},0,{"$f":"D34+E34","v":0.20379000000000003},{"$f":"H34-F34","v":0.3688499999999999},{"$f":"'Rate Design'!F16/100","v":0.57263999999999993},null,{"$f":"(R34-D34)","v":0},null,0,{"$f":"M20","v":0},{"$f":"$N$20","v":0},{"$f":"-E34","v":0},null,{"$f":"H34+J34+O34+P34","v":0.57263999999999993},{"$f":"'Rate Design'!F28/100","v":0.20379000000000003},{"$f":"R34/D34-1","v":0},{"$f":"D34+J34-R34","v":0},{"$f":"H34+J34+M34+N34-Q34+O34+P34","v":0},null,null,null,"GRC",null,{"$f":"J34","v":0},null,0.16283,0,{"$f":"AE24","v":9.7800000000000005E-3},-3.65E-3,{"$f":"AB34+AC34+AD34+AE34+AF34","v":0.16896000000000003},null,{"$f":"Q34-H34","v":0},{"$f":"ROUND(AI34-K34-J34,5)","v":0},null,{"$f":"H34+J34+K34-Q34","v":0},{"$f":"R34-J34-D34","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA33+AA34","v":0.20379000000000003}]
["Transportation Service - Schedule 146"]
["Basic Charge",null,null,{"$f":"'Rate Design'!G4","v":300},null,null,{"$f":"H37-D37","v":0},{"$f":"'Rate Design'!G14","v":300},null,{"$f":"(R37-D37)","v":0},null,null,{"$f":"Q37-H37-J37-L37","v":0},0,null,null,{"$f":"'Rate Design'!G36","v":300},{"$f":"'Rate Design'!G26","v":300},{"$f":"R37/D37-1","v":0},null,null,null,"Ann. Min. calc",null,"Bill @ 250,000",null,{"$f":"12*R37","v":3600}]
["Usage Charge:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"therms",null,{"$f":"250000*R39","v":30580}]
["All Therms",null,null,{"$f":"'Rate Design'!G6/100-AO39","v":0.12232},0,{"$f":"D39+E39","v":0.12232},{"$f":"H39-F39","v":-3.6500000000000005E-3},{"$f":"'Rate Design'!G16/100","v":0.11867},null,{"$f":"(R39-D39)","v":0},null,null,null,{"$f":"N20","v":0},{"$f":"-E39","v":0},{"$f":"'Sch 177'!G15","v":0},{"$f":"H39+J39+O39+P39","v":0.11867},{"$f":"'Rate Design'!G28/100","v":0.12232},{"$f":"R39/D39-1","v":0},{"$f":"D39+J39-R39","v":0},{"$f":"H39+J39+M39+N39-Q39+O39+P39","v":0},null,null,null,null,null,{"$f":"AA37+AA38","v":34180},null,0,0,0,-3.65E-3,{"$f":"AB39+AC39+AD39+AE39+AF39","v":-3.65E-3},null,{"$f":"Q39-H39","v":0},{"$f":"ROUND(AI39-K39-J39,5)","v":0},null,{"$f":"H39+J39+K39-Q39","v":0},{"$f":"R39-J39-D39","v":0},null,0]
[]
[]
["(1) Includes Schedule 150 - Purchased Gas Cost Adjustment, Schedule 155 -  Gas Rate Adjustment, Schedule 175 - Fixed Cost Adjustment and Schedule 191 - DSM, Schedule 176 - Tax Customer Credit"]

{"sheet":"ROR","index":5,"n_rows":56,"n_cols":16,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,6]]}
["AVISTA UTILITIES"]
["IDAHO GAS"]
["PRESENT & PROPOSED RATE OF RETURN BY RATE SCHEDULE"]
["12 MONTHS ENDED June 30, 2022"]
[]
[null,"Not updated for actual Revenue Requirement"]
[null,null,"Total","Sch 101","Sch 111","Sch 131","Sch 146"]
[null,"Total Rate Base",{"$f":"SUM(D8:G8)","v":206556000.00000003},170752986.03739256,33787338.880641066,1.2714039004055849E-2,2015675.0692523723,"from COS",null,null,null,{"$f":"D8/$C$8","v":0.82666679272155019},{"$f":"E8/$C$8","v":0.16357471523771308},{"$f":"F8/$C$8","v":6.1552503941090298E-11},{"$f":"G8/$C$8","v":9.7584919791842018E-3}]
[]
[null,"Revenue From Retail Rates",{"$f":"SUM(D10:G10)","v":47311000},39382000,7428000,0,501000,"From Rate Year 1",null,null,null,{"$f":"D10/$C$10","v":0.83240683984697006},{"$f":"E10/$C$10","v":0.15700365665490054},{"$f":"F10/$C$10","v":0},{"$f":"G10/$C$10","v":1.0589503498129399E-2}]
[null,"Other Operating Revenues",{"$f":"SUM(D11:G11)","v":1692000.0000000028},1398766.1081863791,276728.12370293029,1.0415516208086435E-4,16505.768006538157,"from COS"]
[null,"Total Revenues",{"$f":"IF(ROUND(C10+C11,0)<>ROUND(SUM(D12:G12),0),#VALUE!,SUM(D12:G12))","v":49003000},{"$f":"D10+D11","v":40780766.108186379},{"$f":"E10+E11","v":7704728.1237029303},{"$f":"F10+F11","v":1.0415516208086435E-4},{"$f":"G10+G11","v":517505.76800653816}]
[]
[null,"Total Operating Exp b4 conv items & taxes",{"$f":"SUM(D14:G14)","v":32661999.899999995},{"$f":"D17-D15-D16","v":28221323.982346714},{"$f":"E17-E15-E16","v":4191430.6510848417},{"$f":"F17-F15-F16","v":2.3314368186052583E-3},{"$f":"G17-G15-G16","v":249245.26423700535}]
[null,"Revenue Related conversion items",{"$f":"SUM(D15:G15)","v":156999.99999999997},129971.75944443795,25319.226286781166,0,1709.0142687808543,"from COS"]
[null,"Income Taxes",{"$f":"SUM(D16:G16)","v":1414999.9999999993},1005024.9603738671,379053.33652649313,-3.5713047949333544E-4,30921.70345676961,"from COS"]
[null,"Total Expenses",{"$f":"IF(ROUND(SUM(C14:C16),0)<>ROUND(SUM(D17:G17),0),#VALUE!,SUM(D17:G17))","v":34233999.899999999},29356320.702165019,4595803.2138981158,1.9743063391119229E-3,281875.98196255579,"from COS",null,null,null,{"$f":"D17/$C$17","v":0.85751944814853553},{"$f":"E17/$C$17","v":0.13424674964429489},{"$f":"F17/$C$17","v":5.7670922033037777E-11},{"$f":"G17/$C$17","v":8.2338021494986272E-3}]
[]
[null,"Net Operating Income",{"$f":"IF(ROUND(C12-C17,0)<>ROUND(SUM(D19:G19),0),#VALUE!,SUM(D19:G19))","v":14769000.100000005},{"$f":"D12-D17","v":11424445.40602136},{"$f":"E12-E17","v":3108924.9098048145},{"$f":"F12-F17","v":-1.8701511770310585E-3},{"$f":"G12-G17","v":235629.78604398237}]
[null,"Present Rate of Return",{"$f":"IF(C8,C19/C8,0)","v":7.1501191444450912E-2},{"$f":"IF(D8,D19/D8,0)","v":6.6906270110670643E-2},{"$f":"IF(E8,E19/E8,0)","v":9.2014494565185095E-2},{"$f":"IF(F8,F19/F8,0)","v":-0.14709339623973702},{"$f":"IF(G8,G19/G8,0)","v":0.11689869544865636}]
[null,"Present Return Ratio",{"$f":"C20/$C20","v":1},{"$f":"D20/$C20","v":0.9357364368207759},{"$f":"E20/$C20","v":1.2868945636615148},{"$f":"F20/$C20","v":-2.0572160165192983},{"$f":"G20/$C20","v":1.634919545913786}]
[null,null,null,null,null,null,null,null,null,null,null,"Total","Sch 101","Sch 111","Sch 131","Sch 146"]
[null,"Interest Expense",{"$f":"SUM(D23:G23)","v":4909000},4058107.2854700899,802988.27710193361,3.0216124184681233E-4,47904.437125815275,"from COS",null,null,"Current Margin",{"$f":"SUM(M23:P23)","v":47310.612509999992},{"$f":"'Appendix F Pg 4'!D29","v":39381.34102},{"$f":"'Appendix F Pg 4'!D30","v":7427.9020899999996},{"$f":"'Appendix F Pg 4'!D31","v":2.0000000000000002E-5},{"$f":"'Appendix F Pg 4'!D32","v":501.36937999999998}]
[null,null,null,null,null,null,null,null,null,null,"% of CM",null,{"$f":"M23/$L$23","v":0.83239972874322876},{"$f":"N23/$L$23","v":0.15700287305369323},{"$f":"O23/$L$23","v":4.2273813292467146E-10},{"$f":"P23/$L$23","v":1.0597397780340004E-2}]
[null,"Proposed Misc Revenue Increase",0]
[null,"Proposed Rate Revenue Increase",3000,{"$f":"C26/C10","v":6.3410200587601194E-5},null,null,null,null,null,null,null,{"$f":"SUM(M26:P26)","v":3000.0000000000005},{"$f":"$C$26*M24","v":2497.1991862296863},{"$f":"$C$26*N24","v":471.00861916107971},{"$f":"$C$26*O24","v":1.2682143987740144E-6},{"$f":"$C$26*P24","v":31.792193341020013}]
[null,"Proposed Rev Increase",{"$f":"C25+C26","v":3000}]
[null,null,null,"change"]
[null,"Proposed Rate Revenues",{"$f":"C10+C26","v":47314000},{"$f":"C29-C10","v":3000},null,"Uncollectibles",1.7949999999999999E-3]
[null,"incremental conversion expenses",{"$f":"ROUND(C27*G29,-3)+ROUND(C27*G30,-3)","v":0},null,null,"Commiss Fees",1.9819999999999998E-3]
[null,"incremental Income Taxes",{"$f":"ROUND(C27*G32,-3)+ROUND(C27*G31,-3)","v":1000},null,null,"State Inc Tax",0]
[null,"Proposed Return",{"$f":"C19+C27-C30-C31","v":14771000.100000005},{"$f":"C32-C19","v":2000},null,"Federal Inc Tax",0.209207]
[null,"Proposed Return %",{"$f":"C32/C8","v":7.1510874048684142E-2},null,null,null,null,null,null,null,"    "]
[]
[null,"Allocation of incremental Misc Rev",{"$f":"SUM(D35:G35)","v":0},null,null,null,null,"from COS"]
["(1) Includes Schedule 150/156 - Purchased Gas Cost Adjustment"]
[null,"Target Relative Return",{"$f":"C38/C33","v":1},{"$f":"D39/D8/C33","v":0.9320031491467976},1.3043220241200397,1,1.6590516431945812,"Input"]
[null,"Target Return %",{"$f":"IF(C8,C39/C8,0)","v":7.1510874048684142E-2},{"$f":"IF(D8,D39/D8,0)","v":6.6648359811613628E-2},{"$f":"IF(E8,E39/E8,0)","v":9.3273207985772932E-2},{"$f":"IF(F8,F39/F8,0)","v":7.1510874048684156E-2},{"$f":"IF(G8,G39/G8,0)","v":0.11864023309675016}]
[null,"Target Return (NOI b4 Interest)",{"$f":"C32","v":14771000.100000005},{"$f":"$C$32-SUM(E39:G39)","v":11380406.452327577},{"$f":"E8*E37*$C$32/$C$8","v":3151453.4866998265},{"$f":"F8*F37*$C$32/$C$8","v":9.091920418690955E-4},{"$f":"G8*G37*$C$32/$C$8","v":239140.16006340948},{"$f":"ROUND(C39-SUM(D39:G39),0)","v":0}]
[null,"Target Return after Interest Expense",{"$f":"C39-C23","v":9862000.1000000052},{"$f":"D39-D23","v":7322299.1668574875},{"$f":"E39-E23","v":2348465.2095978931},{"$f":"F39-F23","v":6.0703080002228317E-4},{"$f":"G39-G23","v":191235.7229375942},0]
[null,"Target Return b4 Income Taxes & Interest",{"$f":"C40+C16+C31+C23","v":16187000.100000005},{"$f":"D40+D23+D40/$C40*SUM($C$16,$C$31)","v":12431752.580408655},{"$f":"E40+E23+E40/$C40*SUM($C$16,$C$31)","v":3488649.4614585992},{"$f":"F40+F23+F40/$C40*SUM($C$16,$C$31)","v":9.9635038744967934E-4},{"$f":"G40+G23+G40/$C40*SUM($C$16,$C$31)","v":266598.05713640113},0]
[null,"Target Return b4 Misc Rev",{"$f":"C41-C11-$C$25*C35","v":14495000.100000001},{"$f":"D41-D11-$C$25*D35","v":11032986.472222276},{"$f":"E41-E11-$C$25*E35","v":3211921.3377556689},{"$f":"F41-F11-$C$25*F35","v":8.9219522536881501E-4},{"$f":"G41-G11-$C$25*G35","v":250092.28912986297},0]
[null,{"$f":"B14","v":"Total Operating Exp b4 conv items & taxes"},32661999.899999995,28221323.982346714,4191430.6510848417,2.3314368186052583E-3,249245.26423700535,0]
[null,"Conversion Items",{"$f":"C15+C30","v":156999.99999999997},{"$f":"$C44*D46/$C46","v":130689.54219664801},{"$f":"$C44*E46/$C46","v":24648.011159487669},{"$f":"$C44*F46/$C46","v":1.0732451829080081E-5},{"$f":"$C44*G46/$C46","v":1662.4466331318429},{"$f":"ROUND(C44-SUM(D44:G44),0)","v":0}]
[null,"Incremental Rate Revenue",{"$f":"C26","v":3000},{"$f":"(D42-D10+D14+($C$44*D10)/$C$29)/(1-$C$44/$C$29)","v":2999.9967656375916},{"$f":"(E42-E10+E14+($C$44*E10)/$C$29)/(1-$C$44/$C$29)","v":-1.7301430132985874E-9},{"$f":"(F42-F10+F14+($C$44*F10)/$C$29)/(1-$C$44/$C$29)","v":3.2343644958031533E-3},{"$f":"(G42-G10+G14+($C$44*G10)/$C$29)/(1-$C$44/$C$29)","v":1.6288529951149675E-10},0]
[null,"Target Rate Revenue",{"$f":"C42+C43+C44","v":47314000},{"$f":"D10+D45","v":39384999.996765636},{"$f":"E10+E45","v":7427999.9999999981},{"$f":"F10+F45","v":3.2343644958031533E-3},{"$f":"G10+G45","v":501000.00000000017},0]
[null,"Change in Rate Revenue",{"$f":"IF(C10,C46/C10-1,0)","v":6.3410200587643573E-5},{"$f":"IF(D10,D46/D10-1,0)","v":7.6176851496523312E-5},{"$f":"IF(E10,E46/E10-1,0)","v":-2.2204460492503131E-16},{"$f":"IF(F10,F46/F10-1,0)","v":0},{"$f":"IF(G10,G46/G10-1,0)","v":4.4408920985006262E-16},null,{"$f":"D26","v":6.3410200587601194E-5}]
[]
[null,"Incremental Rate Revenue - rounded",{"$f":"SUM(D49:G49)","v":3000},{"$f":"ROUND(D45,-3)","v":3000},{"$f":"ROUND(E45,-3)","v":0},0,0]
[null,"Target Rate Revenue - rounded",{"$f":"SUM(D50:G50)","v":47314000},39385000,7428000,0,501000]
[]
[]
[null,"Billed Revenue",{"$f":"SUM(D53:I53)","v":105956295.82999998},{"$f":"'Appendix F Pg 4'!H29*1000","v":82439975.399999976},{"$f":"'Appendix F Pg 4'!H30*1000","v":22928882.760000002},{"$f":"'Appendix F Pg 4'!H31*1000","v":0.06},{"$f":"'Appendix F Pg 4'!H32*1000","v":487153.17},{"$f":"'Appendix F Pg 4'!H33*1000","v":100284.44}]
[null,"Billied Percentage Increase",{"$f":"C45/C53","v":2.8313560572307149E-5},{"$f":"D45/D53","v":3.6390073518115006E-5},{"$f":"E45/E53","v":-7.5456926157643588E-17},{"$f":"F45/F53","v":5.3906074930052554E-2},{"$f":"G45/G53","v":3.3436157155971447E-16}]
[]
[null,"% Movement Towards Unity",null,{"$f":"(D37-D21)/(1-D21)","v":-5.8093381214585897E-2},{"$f":"(E37-E21)/(1-E21)","v":-6.0745174938505599E-2},{"$f":"(F37-F21)/(1-F21)","v":1},{"$f":"(G37-G21)/(1-G21)","v":-3.8008118408236993E-2}]

{"sheet":"Bill Determ","index":6,"n_rows":75,"n_cols":8,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["AVISTA UTILITIES"]
["IDAHO NATURAL GAS"]
["ACTUAL / PRO FORMA BILLING DETERMINANTS BY RATE SCHEDULE"]
["12 MONTHS ENDED JUNE 30, 2022"]
[]
[]
["Schedule 101","Total therms","Total Billings"]
["therms per Revenue Run",{"$f":"'Rev Runs CY'!O20","v":70027024.203949988},{"$f":"'Rev Runs CY'!P6","v":1079689}]
[]
[null,null,null,"1001-10000",null,"Total"]
["Schedules 111/112","0-200 thms","201-1000 thms","therms",">10000 thms","therms","Total Billings"]
["therms by block, Sch 111/112",{"$f":"'Block Analysis'!P12+'Block Analysis'!P26","v":3283296.1716},{"$f":"'Block Analysis'!P13+'Block Analysis'!P27","v":8247668.8472199989},{"$f":"'Block Analysis'!P14+'Block Analysis'!P28","v":11206259.59857},{"$f":"'Block Analysis'!P15+'Block Analysis'!P29","v":3500647.9710199996},{"$f":"SUM(B12:E12)","v":26237872.588409998},{"$f":"'Rev Runs CY'!P7+'Rev Runs CY'!P8","v":18727}]
["less: customer moved to Sch 146 (3)",{"$f":"-'Big Schedules'!P15","v":0},{"$f":"-'Big Schedules'!Q15","v":0},{"$f":"-'Big Schedules'!R15","v":0},{"$f":"-'Big Schedules'!S15","v":0},{"$f":"SUM(B13:E13)","v":0},0]
["add: customer moved from Sch 132",{"$f":"'Big Schedules'!P40","v":0},{"$f":"'Big Schedules'!Q40","v":0},{"$f":"'Big Schedules'!R40","v":0},{"$f":"'Big Schedules'!S40","v":0},{"$f":"SUM(B14:E14)","v":0},0]
["Adjusted Sch 111/112 therms",{"$f":"SUM(B12:B14)","v":3283296.1716},8247668.8472199989,11206259.59857,3500647.9710199996,26237872.588409998,18727]
[]
["Total thms. Per Rev. Run(1)",null,null,null,null,{"$f":"'Rev Runs CY'!O21+'Rev Runs CY'!O22","v":26237872.588410001}]
["add: customer moved from Sch 146",null,null,null,null,{"$f":"F13","v":0}]
["add: customer moved from Sch 132",null,null,null,null,{"$f":"F14","v":0}]
["Adjusted Sch 111/112 therms",null,null,null,null,{"$f":"SUM(F17:F19)","v":26237872.588410001}]
["Adjust. To Actual",null,null,null,null,{"$f":"F20-F15","v":0}]
[]
[null,"Total"]
["Schedule 131,132","therms","Total Billings"]
["billed/pro forma therms",{"$f":"'Rev Runs CY'!O23+0.1","v":0.1},{"$f":"'Rev Runs CY'!P9","v":0}]
[]
[null,"Total"]
["Schedule 146","therms","Total Billings"]
["billed/pro forma therms",{"$f":"'Big Schedules'!N18","v":3922248},{"$f":"6*12","v":72}]
[]
["Sch. 147-Special Transportation","Total therms","Total Billings"]
["billed/pro forma therms ",{"$f":"'Big Schedules'!N52","v":1314220},{"$f":"12*1","v":12}]
[]
["Sch. 159","Total therms","Total Billings"]
["Clearwater ",{"$f":"'Big Schedules'!N61","v":51912883},{"$f":"12*1","v":12}]
[]
[null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
["**  These billing determinants do not included the effects of weather or unbilled therm usage"]
[]
[]
[]
[]
[]
[]
["Revenue Run therms, this sheet",{"$f":"B8+F20+B25+B29+B32+B35","v":153414247.89235997}]
[]
["actual Revenue Run therms",{"$f":"'Rev Runs CY'!O27","v":153331037.79235998}]
["add:"]
["Sch 146 Unbilled/Unbilled True-Up",{"$f":"'Big Schedules'!N14+'Big Schedules'!N15+'Big Schedules'!N16","v":61583}]
["Sch 146 Customer Usage Adj",{"$f":"'Big Schedules'!N17","v":21627}]
[null,{"$f":"B52+B54+B55","v":153414247.79235998}]
["Diff",{"$f":"B50-B56","v":9.9999994039535522E-2}]
[]
["from Present Rev tab",{"$f":"SUM('Pres & Prop Rev'!D20:I20)","v":153414247.89235997}]
["this sheet",{"$f":"B50","v":153414247.89235997}]
["Diff",{"$f":"B59-B60","v":0}]
[]
[]
["Rev. Run customers",{"$f":"'Rev Runs CY'!O13*12","v":1098512}]
["less:"]
["customer switching, Sch 111 to 146",0]
["Sch 146 normalize",0]
["Sch 147 normalize",0]
[]
[null,{"$f":"B64-SUM(B65:B69)","v":1098512}]
[]
["from Present Rev tab",{"$f":"SUM('Pres & Prop Rev'!D25:I26)","v":1098512},{"$f":"C8+G15+C25+C29+C32+C35","v":1098512}]
[]
[null,{"$f":"B72+B73","v":1098512}]
["Diff",{"$f":"B70-B74","v":0}]

{"sheet":"Rate Spread","index":7,"n_rows":41,"n_cols":26,"rows_kept":41,"cut":false,"hidden":false,"merged":[[4,0,4,18],[0,0,0,18],[0,24,2,25],[1,0,1,18],[2,0,2,18],[3,0,3,18]]}
["AVISTA UTILITIES"]
["IDAHO GAS, CASE NO. AVU-G-23-01"]
["PROPOSED INCREASE BY SERVICE SCHEDULE"]
["12 MONTHS ENDED JUNE 30, 2022"]
["(000s of Dollars)"]
[]
["Effective September 1, 2023",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sch 197",null,"Sch 197"]
[null,null,null,"Base Tariff",null,null,"Settlement","Base Tariff","Base","Total Billed",null,null,"Sch 176","Total Billed","Percent ","Total","Percent ","Total","Percent ","Total Billed","Percent ","Percent "]
[null,null,null,"Distribution Revenue","Proposed","Percentage","Base","Distribution Revenue","Tariff","Revenue","Total ","Sch 176","Tax Credit","Revenue"," Increase on","Sch 197 - 2014"," Increase on","Sch 197 - 2014"," Increase on","Revenue"," Increase","Total Increase"]
["Line","Type of","Schedule","Under Present","General","of ","Rate","Under Proposed","Percent","at Present","General","Tax Credit","Percent","at Proposed","Billed GRC","Earnings/DSM","Billed GRC","Earnings","Billed GRC","at Proposed","on Billed","on Billed"]
["No.","Service","Number","Rates (1)","Change","Base Change","Change","Rates","Increase","Rates (2)","Change","Decrease","Decrease","Rates (2)","Revenue","Rebate Expiration (2)","Revenue","Rebate","Revenue","Rates (2)","Revenue","Revenue (2)"]
[null,"(a)","(b)","(c)","(d)","(d)","(e)","(f)","(g)","(h)","(i)","(j)","(k)","(l)","(k)","(l)","(m)","(n)","(o)","(k)","(o)","(m)"]
[]
[1,"General Service","101",{"$f":"'Appendix F Pg 4'!D14","v":38129.500520000001},null,1,{"$f":"D14*($Z$21*F14)","v":413.92280059872786},{"$f":"D14+G14","v":38543.423320598726},{"$f":"G14/D14","v":1.0855710013342915E-2},{"$f":"'Appendix F Pg 4'!H14","v":79669.212899999984},{"$f":"G14","v":413.92280059872786},{"$f":"((G14/$G$19)*$Y$24)","v":0},{"$f":"L14/J14","v":0},{"$f":"+K14+J14+L14","v":80083.135700598708},{"$f":"ROUND(E14/J14,3)","v":0},0,{"$f":"ROUND(P14/J14,3)","v":0},0,{"$f":"ROUND(R14/J14,3)","v":0},{"$f":"J14+K14+P14+R14","v":80083.135700598708},{"$f":"O14+Q14+S14","v":0},{"$f":"(K14+L14)/J14","v":5.1955176351281352E-3}]
[2,"Large General Service","111/112",{"$f":"'Appendix F Pg 4'!D15","v":7427.8401399999993},null,0,{"$f":"D15*($Z$21*F15)","v":0},{"$f":"D15+G15","v":7427.8401399999993},{"$f":"G15/D15","v":0},{"$f":"'Appendix F Pg 4'!H15","v":22929.080559999999},{"$f":"G15","v":0},{"$f":"((G15/$G$19)*$Y$24)","v":0},{"$f":"L15/J15","v":0},{"$f":"+K15+J15+L15","v":22929.080559999999},{"$f":"E15/J15","v":0},0,{"$f":"P15/J15","v":0},0,0,{"$f":"J15+K15+P15+R15","v":22929.080559999999},{"$f":"O15+Q15+S15","v":0},{"$f":"(K15+L15)/J15","v":0}]
[3,"Interruptible Service ","131/132",{"$f":"'Appendix F Pg 4'!D16","v":2.0000000000000002E-5},null,0,0,2.0000000000000002E-5,0,{"$f":"'Appendix F Pg 4'!H16","v":5.9999999999999995E-5},0,0,0,5.9999999999999995E-5,{"$f":"E16/J16","v":0},0,{"$f":"P16/J16","v":0},0,0,{"$f":"J16+K16+P16+R16","v":5.9999999999999995E-5},0,0]
[4,"Transportation Service","146",{"$f":"'Appendix F Pg 4'!D17","v":501.36937999999998},null,0,0,501.36937999999998,0,{"$f":"'Appendix F Pg 4'!H17","v":487.05316999999997},0,0,0,487.05316999999997,{"$f":"E17/J17","v":0},0,{"$f":"P17/J17","v":0},0,0,{"$f":"J17+K17+P17+R17","v":487.05316999999997},0,{"$f":"(K17+L17)/J17","v":0}]
[5,"Special Contracts","148",{"$f":"'Appendix F Pg 4'!D18","v":100.28444},null,0,0,100.28444,0,{"$f":"'Appendix F Pg 4'!H18","v":100.28444},0,0,0,100.28444,{"$f":"E18/J18","v":0},0,{"$f":"P18/J18","v":0},0,0,{"$f":"J18+K18+P18+R18","v":100.28444},0,0]
[6,"Total",null,{"$f":"SUM(D14:D18)","v":46158.994500000001},{"$f":"SUM(E14:E18)","v":0},null,{"$f":"SUM(G14:G18)","v":413.92280059872786},{"$f":"SUM(H14:H18)","v":46572.917300598725},{"$f":"G19/D19","v":8.967327063390167E-3},{"$f":"SUM(J14:J18)","v":103185.63112999999},{"$f":"SUM(K14:K18)","v":413.92280059872786},{"$f":"SUM(L14:L18)","v":0},{"$f":"L19/J19","v":0},{"$f":"+K19+J19+L19","v":103599.55393059872},{"$f":"E19/J19","v":0},{"$f":"SUM(P14:P18)","v":0},{"$f":"P19/J19","v":0},{"$f":"SUM(R14:R18)+0.4","v":0.4},0,{"$f":"SUM(T14:T18)","v":103599.55393059872},0,4.0114383763107568E-3]
[null,null,null,{"$f":"ROUND(D19-SUM(D14:D18),0)","v":0},{"$f":"ROUND(E19-SUM(E14:E18),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev Req",500,{"$f":"(Y21)/SUM(D14:D17)","v":1.0855710013342915E-2}]
[]
[]
["Effective September 1, 2024",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Offset",0]
[]
[null,null,null,"Base Tariff",null,null,"Settlement","Base Tariff","Base","Total Billed",null,"Incremental","Sch 176","Total Billed","Percent ","Total","Percent ","Total","Percent ","Total Billed","Percent ","Percent "]
[null,null,null,"Distribution Revenue","Proposed","Percentage","Base","Distribution Revenue","Tariff","Revenue","Total ","Sch 176","Tax Credit","Revenue"," Increase on","Sch 197 - 2014"," Increase on","Sch 197 - 2014"," Increase on","Revenue"," Increase","Total Increase"]
["Line","Type of","Schedule","Under Present","General","of ","Rate","Under Proposed","Percent","at Present","General","Tax Credit","Percent","at Proposed","Billed GRC","Earnings/DSM","Billed GRC","Earnings","Billed GRC","at Proposed","on Billed","on Billed"]
["No.","Service","Number","Rates (1)","Increase","Base Change","Change","Rates","Increase","Rates (2)","Increase","Decrease","Decrease","Rates (2)","Revenue","Rebate Expiration (2)","Revenue","Rebate","Revenue","Rates (2)","Revenue","Revenue (2)"]
[null,"(a)","(b)","(c)","(d)","(d)","(e)","(f)","(g)","(h)","(i)","(j)","(k)","(l)","(k)","(l)","(m)","(n)","(o)","(k)","(o)","(m)"]
[]
[1,"General Service","101",{"$f":"H14","v":38543.423320598726},null,1,{"$f":"((G14/$G$19)*$Y$39)","v":1000},{"$f":"D32+G32","v":39543.423320598726},{"$f":"G32/D32","v":2.5944763434273647E-2},{"$f":"N14","v":80083.135700598708},{"$f":"G32","v":1000},0,{"$f":"L32/J32","v":0},{"$f":"+K32++L32","v":1000},{"$f":"ROUND(E32/J32,3)","v":0},0,{"$f":"ROUND(P32/J32,3)","v":0},0,{"$f":"ROUND(R32/J32,3)","v":0},{"$f":"J32+K32+P32+R32","v":81083.135700598708},{"$f":"O32+Q32+S32","v":0},{"$f":"(K32+L32)/J32","v":1.2487023531878558E-2}]
[2,"Large General Service","111/112",{"$f":"H15","v":7427.8401399999993},null,0,{"$f":"((G15/$G$19)*$Y$39)","v":0},{"$f":"D33+G33","v":7427.8401399999993},{"$f":"G33/D33","v":0},{"$f":"N15","v":22929.080559999999},{"$f":"G33","v":0},0,{"$f":"L33/J33","v":0},{"$f":"+K33++L33","v":0},{"$f":"E33/J33","v":0},0,{"$f":"P33/J33","v":0},0,0,{"$f":"J33+K33+P33+R33","v":22929.080559999999},{"$f":"O33+Q33+S33","v":0},{"$f":"(K33+L33)/J33","v":0}]
[3,"Interruptible Service ","131/132",2.0000000000000002E-5,null,0,0,2.0000000000000002E-5,0,5.9999999999999995E-5,0,0,0,0,{"$f":"E34/J34","v":0},0,{"$f":"P34/J34","v":0},0,0,{"$f":"J34+K34+P34+R34","v":5.9999999999999995E-5},0,0]
[4,"Transportation Service","146",501.36937999999998,null,0,0,501.36937999999998,0,487.05316999999997,0,0,0,0,{"$f":"E35/J35","v":0},0,{"$f":"P35/J35","v":0},0,0,{"$f":"J35+K35+P35+R35","v":487.05316999999997},0,0]
[5,"Special Contracts","148",100.28444,null,0,0,100.28444,0,100.28444,0,0,0,0,{"$f":"E36/J36","v":0},0,{"$f":"P36/J36","v":0},0,0,{"$f":"J36+K36+P36+R36","v":100.28444},0,0]
[6,"Total",null,{"$f":"SUM(D32:D36)","v":46572.917300598725},{"$f":"SUM(E32:E36)","v":0},null,{"$f":"SUM(G32:G36)","v":1000},{"$f":"SUM(H32:H36)","v":47572.917300598725},{"$f":"G37/D37","v":2.1471706261079426E-2},{"$f":"SUM(J32:J36)","v":103599.55393059872},{"$f":"SUM(K32:K36)","v":1000},0,{"$f":"L37/J37","v":0},{"$f":"+K37+J37","v":104599.55393059872},{"$f":"E37/J37","v":0},{"$f":"SUM(P32:P36)","v":0},{"$f":"P37/J37","v":0},{"$f":"SUM(R32:R36)+0.4","v":0.4},0,{"$f":"SUM(T32:T36)","v":104599.55393059872},0,9.6525512133951788E-3]
[null,null,null,{"$f":"ROUND(D37-SUM(D32:D36),0)","v":0},{"$f":"ROUND(E37-SUM(E32:E36),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev Req",1000,{"$f":"Y39/D37","v":2.1471706261079426E-2}]
["(1) Excludes Schedule 150 - Purchased Gas Cost Adjustment, Schedule 155 - Gas Rate Adjustment, & Schedule 191 - DSM"]
["(2) Includes Schedule 150 - Purchased Gas Cost Adjustment, Schedule 155 - Gas Rate Adjustment, & Schedule 191 - DSM"]

{"sheet":"Sch 177","index":8,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[]
["Schedule 177"]
["Deferred Depreciation Credit Rate"]
[]
[]
[null,null,null,"Base Tariff"]
[null,null,null,"Distribution Revenue","Schedule 177",null,"Schedule 177"]
["Line","Type of","Schedule","Under Present","Tax Credit","Test Year","Rate"]
["No.","Service","Number","Rates (1)","Change","Therms","Per Therm"]
[null,"(a)","(b)","(c)"]
[]
[1,"General Service","101",{"$f":"'Pres & Prop Rev'!$D$145/1000","v":39381.34102},{"$f":"D12/$D$16*-$E$21","v":0},{"$f":"'Pres & Prop Rev'!D46","v":69479506.203949988},{"$f":"E12/F12","v":0},null,null,{"$f":"G12*F12","v":0}]
[2,"Large General Service","111/112",{"$f":"'Pres & Prop Rev'!$E$145/1000","v":7427.9020899999996},{"$f":"D13/$D$16*-$E$21","v":0},{"$f":"'Pres & Prop Rev'!E46","v":26075117.588409998},{"$f":"E13/F13","v":0},null,null,{"$f":"G13*F13","v":0}]
[3,"Interruptible Service ","131/132",{"$f":"'Pres & Prop Rev'!$F$145/1000","v":2.0000000000000002E-5},{"$f":"D14/$D$16*-$E$21","v":0},{"$f":"'Pres & Prop Rev'!F46","v":0.1},null,null,null,0]
[4,"Transportation Service","146",{"$f":"'Pres & Prop Rev'!$G$145/1000","v":501.36937999999998},{"$f":"D15/$D$16*-$E$21","v":0},{"$f":"'Pres & Prop Rev'!G46","v":3922248},0,null,null,0]
[6,"Total",null,{"$f":"'Pres & Prop Rev'!$C$145/1000","v":47410.896950000002},{"$f":"D16/$D$16*-$E$21","v":0},null,null,null,null,{"$f":"SUM(J12:J15)","v":0}]
[]
[]
[null,null,null,"Total",0]
[null,null,null,"Conversion Factor",{"$f":"1-0.002593-0.002401","v":0.99500600000000006}]
[null,null,null,"Annual Amt",{"$f":"E19/E20","v":0},"one year amortization"]

{"sheet":"Residential Bill","index":9,"n_rows":93,"n_cols":12,"rows_kept":93,"cut":false,"hidden":false,"merged":[]}
[]
["Schedule 101 Bill Impact"]
[]
["Effective September 1, 2024"]
[]
["Schedule 101 Present",null,null,null,null,"Schedule 101 Proposed"]
[null,"Basic Charge","Block 1","Total Bill",null,"Basic Charge","Block 1","Block 2","Total Bill",null,"Bill Impact","% Change"]
[null,{"$f":"'Appendix F Pg 6'!H18","v":15},{"$f":"'Appendix F Pg 6'!H20","v":0.93158000000000019},null,null,{"$f":"'Appendix F Pg 6'!Q18","v":20},{"$f":"'Appendix F Pg 6'!Q20","v":0.85392000000000023},0]
[10,{"$f":"$B$8","v":15},{"$f":"A9*$C$8","v":9.3158000000000012},{"$f":"SUM(B9:C9)","v":24.315800000000003},null,{"$f":"$F$8","v":20},{"$f":"A9*$G$8","v":8.5392000000000028},null,{"$f":"SUM(F9:H9)","v":28.539200000000001},null,{"$f":"I9-D9","v":4.223399999999998},{"$f":"K9/D9","v":0.1736895351993353}]
[{"$f":"A9+10","v":20},{"$f":"$B$8","v":15},18.631600000000002,33.631600000000006,null,{"$f":"$F$8","v":20},17.078400000000006,null,37.078400000000002,null,3.4467999999999961,0.10248694680003317]
[{"$f":"A10+10","v":30},15,27.947400000000005,42.947400000000002,null,20,25.617600000000007,null,45.61760000000001,null,2.6702000000000083,6.2173728793827057E-2]
[40,15,37.263200000000005,52.263200000000005,null,20,34.156800000000011,null,54.156800000000011,null,1.8936000000000064,3.6231994979258948E-2]
[50,15,46.579000000000008,61.579000000000008,null,20,42.696000000000012,null,62.696000000000012,null,1.1170000000000044,1.8139300735640466E-2]
[60,15,55.894800000000011,70.894800000000004,null,20,51.235200000000013,null,71.23520000000002,null,0.34040000000001669,4.801480503506839E-3]
[{"$f":"ROUND('Pres & Prop Rev'!D46/'Pres & Prop Rev'!D48,0)","v":64},15,{"$f":"ROUND(A15*$C$8,2)","v":59.62},74.62,null,20,{"$f":"ROUND(A15*$G$8,2)","v":54.65},null,{"$f":"SUM(F15:H15)","v":74.650000000000006},null,3.0000000000001137E-2,4.0203698740285629E-4]
[{"$f":"A14+10","v":70},15,{"$f":"ROUND(A16*$C$8,2)","v":65.209999999999994},80.209999999999994,null,20,{"$f":"ROUND(A16*$G$8,2)","v":59.77},null,79.77000000000001,null,{"$f":"I16-D16","v":-0.43999999999998352},-5.4856002992143566E-3]
[80,15,{"$f":"A17*$C$8","v":74.52640000000001},89.52640000000001,null,20,{"$f":"A17*$G$8","v":68.313600000000022},null,88.313600000000022,null,-1.2127999999999872,-1.3546842048825678E-2]
[90,15,{"$f":"A18*$C$8","v":83.84220000000002},98.84220000000002,null,20,{"$f":"A18*$G$8","v":76.852800000000016},null,96.852800000000016,null,-1.9894000000000034,-2.012703076216437E-2]
[100,15,93.158000000000015,108.15800000000002,null,20,85.392000000000024,null,105.39200000000002,null,-2.7659999999999911,-2.5573697738493599E-2]
[110,15,102.47380000000003,117.47380000000003,null,20,93.931200000000032,null,113.93120000000003,null,-3.5425999999999931,-3.0156511494477851E-2]
[120,15,111.78960000000002,126.78960000000002,null,20,102.47040000000003,null,122.47040000000003,null,-4.319199999999995,-3.406588553004343E-2]
[130,15,121.10540000000002,136.10540000000003,null,20,111.00960000000003,null,131.00960000000003,null,-5.095799999999997,-3.7440101568343327E-2]
[140,15,130.42120000000003,145.42120000000003,null,20,119.54880000000003,null,139.54880000000003,null,-5.872399999999999,-4.0382007575236606E-2]
[150,15,139.73700000000002,154.73700000000002,null,20,128.08800000000002,null,148.08800000000002,null,-6.6490000000000009,-4.2969684044540088E-2]
[160,15,149.05280000000002,164.05280000000002,null,20,136.62720000000004,null,156.62720000000004,null,-7.4255999999999744,-4.5263476149142064E-2]
[170,15,158.36860000000004,173.36860000000004,null,20,145.16640000000004,null,165.16640000000004,null,-8.2022000000000048,-4.7310758695634635E-2]
[180,15,167.68440000000004,182.68440000000004,null,20,153.70560000000003,null,173.70560000000003,null,-8.9788000000000068,-4.9149243175662535E-2]
[190,15,177.00020000000004,192.00020000000004,null,20,162.24480000000005,null,182.24480000000005,null,-9.7553999999999803,-5.080932207362273E-2]
[200,15,186.31600000000003,201.31600000000003,null,20,170.78400000000005,null,190.78400000000005,null,-10.531999999999982,-5.2315762284170064E-2]
[210,15,195.63180000000003,210.63180000000003,null,20,179.32320000000004,null,199.32320000000004,null,-11.308599999999984,-5.3688949152027293E-2]
[220,15,204.94760000000005,219.94760000000005,null,20,187.86240000000006,null,207.86240000000006,null,-12.085199999999986,-5.4945814366694538E-2]
[230,15,214.26340000000005,229.26340000000005,null,20,196.40160000000006,null,216.40160000000006,null,-12.861799999999988,-5.6100537634877552E-2]
[240,15,223.57920000000004,238.57920000000004,null,20,204.94080000000005,null,224.94080000000005,null,-13.63839999999999,-5.7165083963731905E-2]
[250,15,232.89500000000004,247.89500000000004,null,20,213.48000000000005,null,233.48000000000005,null,-14.414999999999992,-5.8149619798705053E-2]
[260,15,242.21080000000003,257.21080000000006,null,20,222.01920000000007,null,242.01920000000007,null,-15.191599999999994,-5.9062838729944431E-2]
[270,15,251.52660000000006,266.52660000000003,null,20,230.55840000000006,null,250.55840000000006,null,-15.968199999999968,-5.9912218892973407E-2]
[280,15,260.84240000000005,275.84240000000005,null,20,239.09760000000006,null,259.09760000000006,null,-16.744799999999998,-6.0704228211471457E-2]
[290,15,270.15820000000008,285.15820000000008,null,20,247.63680000000008,null,267.63680000000011,null,-17.521399999999971,-6.1444489409738054E-2]
[300,15,279.47400000000005,294.47400000000005,null,20,256.17600000000004,null,276.17600000000004,null,-18.298000000000002,-6.2137913703756528E-2]
[310,15,288.78980000000007,303.78980000000007,null,20,264.7152000000001,null,{"$f":"SUM(F40:H40)","v":284.7152000000001},null,-19.074599999999975,-6.2788809894209652E-2]
[320,15,298.10560000000004,313.10560000000004,null,20,273.25440000000009,null,293.25440000000009,null,-19.851199999999949,-6.340097398449579E-2]
[330,15,307.42140000000006,322.42140000000006,null,20,281.79360000000008,null,301.79360000000008,null,-20.627799999999979,-6.3977763262612147E-2]
[340,15,316.73720000000009,331.73720000000009,null,20,290.33280000000008,null,310.33280000000008,null,-21.40440000000001,-6.4522157900892649E-2]
[350,15,326.05300000000005,341.05300000000005,null,20,298.87200000000007,null,318.87200000000007,null,-22.180999999999983,-6.5036812460233392E-2]
[360,15,335.36880000000008,350.36880000000008,null,20,307.41120000000006,null,327.41120000000006,null,-22.957600000000014,-6.5524099177780695E-2]
[370,15,344.68460000000005,359.68460000000005,null,20,315.95040000000006,null,335.95040000000006,null,-23.734199999999987,-6.5986144527733423E-2]
[380,15,354.00040000000007,369.00040000000007,null,20,324.48960000000011,null,344.48960000000011,null,-24.510799999999961,-6.6424860244053821E-2]
[390,15,363.31620000000009,378.31620000000009,null,20,333.0288000000001,null,353.0288000000001,null,-25.287399999999991,-6.6841969759687758E-2]
[400,15,372.63200000000006,387.63200000000006,null,20,341.5680000000001,null,361.5680000000001,null,-26.063999999999965,-6.723903083336763E-2]
[]
[]
[]
["Breakeven Analysis (Base Rates - Includes Cost of Gas)"]
[]
["Schedule 101",null,null,null,null,"Schedule 111"]
[null,"Basic Charge","Block 1","Total Bill",null,"Minimum Charge","Block 1","Block 2",null,"Total Bill",null,"Bill Differential"]
[null,{"$f":"'Appendix F Pg 6'!R18","v":20},{"$f":"'Appendix F Pg 6'!R20","v":0.25605},null,null,{"$f":"'Appendix F Pg 6'!R29","v":71.209999999999994},0,{"$f":"'[1]Rate Design'!E29/100","v":0.85647000000000006}]
[10,{"$f":"$B$57","v":20},{"$f":"A58*$C$57","v":2.5605000000000002},{"$f":"SUM(B58:C58)","v":22.560500000000001},null,{"$f":"$F$57","v":71.209999999999994},{"$f":"A58*$G$57","v":0},null,null,{"$f":"SUM(F58:I58)","v":71.209999999999994},null,{"$f":"J58-D58","v":48.649499999999989}]
[{"$f":"A58+10","v":20},20,5.1210000000000004,{"$f":"SUM(B59:C59)","v":25.121000000000002},null,{"$f":"$F$57","v":71.209999999999994},{"$f":"A59*$G$57","v":0},null,null,{"$f":"SUM(F59:I59)","v":71.209999999999994},null,46.088999999999992]
[{"$f":"A59+10","v":30},20,7.6814999999999998,27.6815,null,71.209999999999994,0,null,null,71.209999999999994,null,43.528499999999994]
[40,20,10.242000000000001,30.242000000000001,null,71.209999999999994,0,null,null,71.209999999999994,null,40.967999999999989]
[50,20,12.8025,32.802500000000002,null,71.209999999999994,0,null,null,71.209999999999994,null,38.407499999999992]
[60,20,15.363,35.363,null,71.209999999999994,0,null,null,71.209999999999994,null,35.846999999999994]
[70,20,17.923500000000001,37.923500000000004,null,71.209999999999994,0,null,null,71.209999999999994,null,33.28649999999999]
[80,20,{"$f":"A65*$C$57","v":20.484000000000002},40.484000000000002,null,71.209999999999994,0,null,null,71.209999999999994,null,30.725999999999992]
[90,20,23.044499999999999,43.044499999999999,null,71.209999999999994,0,null,null,71.209999999999994,null,28.165499999999994]
[100,20,25.605,45.605000000000004,null,71.209999999999994,0,null,null,71.209999999999994,null,25.60499999999999]
[110,20,28.165500000000002,48.165500000000002,null,71.209999999999994,0,null,null,71.209999999999994,null,23.044499999999992]
[120,20,30.725999999999999,50.725999999999999,null,71.209999999999994,0,null,null,71.209999999999994,null,20.483999999999995]
[130,20,33.286499999999997,53.286499999999997,null,71.209999999999994,0,null,null,71.209999999999994,null,17.923499999999997]
[140,20,35.847000000000001,55.847000000000001,null,71.209999999999994,0,null,null,71.209999999999994,null,15.362999999999992]
[150,20,38.407499999999999,58.407499999999999,null,71.209999999999994,0,null,null,71.209999999999994,null,12.802499999999995]
[160,20,40.968000000000004,60.968000000000004,null,71.209999999999994,0,null,null,71.209999999999994,null,10.24199999999999]
[170,20,43.528500000000001,63.528500000000001,null,71.209999999999994,0,null,null,71.209999999999994,null,7.6814999999999927]
[180,20,46.088999999999999,66.088999999999999,null,71.209999999999994,0,null,null,71.209999999999994,null,5.1209999999999951]
[190,20,48.649500000000003,68.649500000000003,null,71.209999999999994,0,null,null,71.209999999999994,null,2.5604999999999905]
[200,20,51.21,71.210000000000008,null,71.209999999999994,0,null,null,71.209999999999994,null,0]
[210,20,53.770499999999998,73.770499999999998,null,71.209999999999994,{"$f":"200*$G$57","v":0},{"$f":"(A78-200)*$H$57","v":8.5647000000000002},null,79.774699999999996,null,6.0041999999999973]
[220,20,56.331000000000003,76.331000000000003,null,71.209999999999994,0,{"$f":"(A79-200)*$H$57","v":17.1294},null,88.339399999999998,null,12.008399999999995]
[230,20,58.891500000000001,78.891500000000008,null,71.209999999999994,0,25.694100000000002,null,96.9041,null,18.012599999999992]
[240,20,61.451999999999998,81.451999999999998,null,71.209999999999994,0,34.258800000000001,null,105.46879999999999,null,24.016799999999989]
[250,20,64.012500000000003,84.012500000000003,null,71.209999999999994,0,42.823500000000003,null,114.0335,null,30.021000000000001]
[260,20,66.572999999999993,86.572999999999993,null,71.209999999999994,0,51.388200000000005,null,122.59819999999999,null,36.025199999999998]
[270,20,69.133499999999998,89.133499999999998,null,71.209999999999994,0,59.952900000000007,null,131.16290000000001,null,42.02940000000001]
[280,20,71.694000000000003,91.694000000000003,null,71.209999999999994,0,68.517600000000002,null,139.7276,null,48.033599999999993]
[290,20,74.254499999999993,94.254499999999993,null,71.209999999999994,0,77.082300000000004,null,148.29230000000001,null,54.037800000000018]
[300,20,76.814999999999998,96.814999999999998,null,71.209999999999994,0,85.647000000000006,null,156.857,null,60.042000000000002]
[310,20,79.375500000000002,99.375500000000002,null,71.209999999999994,0,94.211700000000008,null,165.42169999999999,null,66.046199999999985]
[320,20,81.936000000000007,101.93600000000001,null,71.209999999999994,0,102.77640000000001,null,173.9864,null,72.050399999999996]
[330,20,84.496499999999997,104.4965,null,71.209999999999994,0,111.34110000000001,null,182.55110000000002,null,78.054600000000022]
[340,20,87.057000000000002,107.057,null,71.209999999999994,0,119.90580000000001,null,191.11580000000001,null,84.058800000000005]
[350,20,89.617500000000007,109.61750000000001,null,71.209999999999994,0,128.47050000000002,null,199.68049999999999,null,90.062999999999988]
[500,20,128.02500000000001,148.02500000000001,null,71.209999999999994,0,{"$f":"(A93-200)*$H$57","v":256.94100000000003},null,{"$f":"SUM(F93:I93)","v":328.15100000000001},null,180.126]

{"sheet":"Big Schedules","index":10,"n_rows":66,"n_cols":27,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
["Idaho Gas Billing Determinants by Customer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Present",null,null,null,"Proposed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1st",200,1000,10000,null,null,null,"Total ",null,null,null,"Total "]
["ANNUAL USAGE, Sch 146",null,null,null,null,null,null,null,null,null,null,null,null,"12-mo ended",null,200,1000,10000,99999999,null,"Base","Monthly ","Base ",null,"Base","Monthly ","Base "]
["Idaho","2022-01-01","2022-02-01","2022-03-01","2022-04-01","2022-05-01","2022-06-01","2021-07-01","2021-08-01","2021-09-01","2021-10-01","2021-11-01","2021-12-01","Total",null,"thms/mo","thms/mo","thms/mo","thms/mo",null,"Revenue","Minimum","Revenue",null,"Revenue","Minimum","Revenue"]
["Coeur d'Alene Resort",53429,48105,44290,41615,34989,27448,24055,24251,24978,32221,38100,59166,{"$f":"SUM(B5:M5)","v":452647},null,{"$f":"P$3*12-SUMPRODUCT(--(ABS($B5:$M5)<=P$3),P$3-ABS($B5:$M5))","v":2400},{"$f":"Q$3*12-P5-SUMPRODUCT(--(ABS($B5:$M5)<=Q$3),Q$3-ABS($B5:$M5))","v":9600},{"$f":"R$3*12-SUM($P5:Q5)-SUMPRODUCT(--(ABS($B5:$M5)<=R$3),R$3-ABS($B5:$M5))","v":108000},{"$f":"S$3*12-SUM($P5:R5)-SUMPRODUCT(--(ABS($B5:$M5)<=S$3),S$3-ABS($B5:$M5))","v":332647},null,{"$f":"(12*'Appendix F Pg 6'!$D$37)+(N5*(0.13441-0.00897))","v":60380.039680000002},{"$f":"IF(U5<$V$15,$V$15-U5,0)","v":0},{"$f":"U5+V5","v":60380.039680000002},null,{"$f":"(12*'Appendix F Pg 6'!$R$37)+(N5*'Appendix F Pg 6'!$R$39)","v":58967.781040000002},{"$f":"IF(N5<250000,(250000-N5)*'Appendix F Pg 6'!$R$39,0)","v":0},{"$f":"Y5+Z5","v":58967.781040000002}]
["Idaho Asphalt",37272,47212,83613,116823,138176,124935,114701,111647,91126,92895,85237,48485,1092122,null,{"$f":"P$3*12-SUMPRODUCT(--(ABS($B6:$M6)<=P$3),P$3-ABS($B6:$M6))","v":2400},{"$f":"Q$3*12-P6-SUMPRODUCT(--(ABS($B6:$M6)<=Q$3),Q$3-ABS($B6:$M6))","v":9600},{"$f":"R$3*12-SUM($P6:Q6)-SUMPRODUCT(--(ABS($B6:$M6)<=R$3),R$3-ABS($B6:$M6))","v":108000},{"$f":"S$3*12-SUM($P6:R6)-SUMPRODUCT(--(ABS($B6:$M6)<=S$3),S$3-ABS($B6:$M6))","v":972122},null,{"$f":"(12*'Appendix F Pg 6'!$D$37)+(N6*(0.13441-0.00897))","v":140595.78367999999},0,140595.78367999999,null,{"$f":"(12*'Appendix F Pg 6'!$R$37)+(N6*'Appendix F Pg 6'!$R$39)","v":137188.36304},{"$f":"IF(N6<250000,(250000-N6)*'Appendix F Pg 6'!$R$39,0)","v":0},137188.36304]
["Idaho Forest Group LLC",80337,39562,64739,48981,21627,25348,165978,13501,53555,20768,23318,64757,622471,null,{"$f":"P$3*12-SUMPRODUCT(--(ABS($B7:$M7)<=P$3),P$3-ABS($B7:$M7))","v":2400},{"$f":"Q$3*12-P7-SUMPRODUCT(--(ABS($B7:$M7)<=Q$3),Q$3-ABS($B7:$M7))","v":9600},{"$f":"R$3*12-SUM($P7:Q7)-SUMPRODUCT(--(ABS($B7:$M7)<=R$3),R$3-ABS($B7:$M7))","v":108000},{"$f":"S$3*12-SUM($P7:R7)-SUMPRODUCT(--(ABS($B7:$M7)<=S$3),S$3-ABS($B7:$M7))","v":502471},null,{"$f":"(12*'Appendix F Pg 6'!$D$37)+(N7*(0.13441-0.00897))","v":81682.762239999996},0,81682.762239999996,null,{"$f":"(12*'Appendix F Pg 6'!$R$37)+(N7*'Appendix F Pg 6'!$R$39)","v":79740.652719999998},{"$f":"IF(N7<250000,(250000-N7)*'Appendix F Pg 6'!$R$39,0)","v":0},79740.652719999998]
["Kootenai Medical Center",79035,71378,64509,62279,57874,48069,43865,48977,48896,58948,63161,81609,728600,null,{"$f":"P$3*12-SUMPRODUCT(--(ABS($B8:$M8)<=P$3),P$3-ABS($B8:$M8))","v":2400},{"$f":"Q$3*12-P8-SUMPRODUCT(--(ABS($B8:$M8)<=Q$3),Q$3-ABS($B8:$M8))","v":9600},{"$f":"R$3*12-SUM($P8:Q8)-SUMPRODUCT(--(ABS($B8:$M8)<=R$3),R$3-ABS($B8:$M8))","v":108000},{"$f":"S$3*12-SUM($P8:R8)-SUMPRODUCT(--(ABS($B8:$M8)<=S$3),S$3-ABS($B8:$M8))","v":608600},null,{"$f":"(12*'Appendix F Pg 6'!$D$37)+(N8*(0.13441-0.00897))","v":94995.584000000003},0,94995.584000000003,null,{"$f":"(12*'Appendix F Pg 6'!$R$37)+(N8*'Appendix F Pg 6'!$R$39)","v":92722.351999999999},{"$f":"IF(N8<250000,(250000-N8)*'Appendix F Pg 6'!$R$39,0)","v":0},92722.351999999999]
["North Idaho Energy Logs ",63147,45946,56723,50517,29804,44348,40910,46987,39539,38450,51550,61111,569032,null,{"$f":"P$3*12-SUMPRODUCT(--(ABS($B9:$M9)<=P$3),P$3-ABS($B9:$M9))","v":2400},{"$f":"Q$3*12-P9-SUMPRODUCT(--(ABS($B9:$M9)<=Q$3),Q$3-ABS($B9:$M9))","v":9600},{"$f":"R$3*12-SUM($P9:Q9)-SUMPRODUCT(--(ABS($B9:$M9)<=R$3),R$3-ABS($B9:$M9))","v":108000},{"$f":"S$3*12-SUM($P9:R9)-SUMPRODUCT(--(ABS($B9:$M9)<=S$3),S$3-ABS($B9:$M9))","v":449032},null,{"$f":"(12*'Appendix F Pg 6'!$D$37)+(N9*(0.13441-0.00897))","v":74979.374079999994},0,74979.374079999994,null,{"$f":"(12*'Appendix F Pg 6'!$R$37)+(N9*'Appendix F Pg 6'!$R$39)","v":73203.99424},{"$f":"IF(N9<250000,(250000-N9)*'Appendix F Pg 6'!$R$39,0)","v":0},73203.99424]
["Univ of Idaho",38141,11693,5797,4891,83847,57639,963,626,43249,69274,115872,25384,457376,null,{"$f":"P$3*12-SUMPRODUCT(--(ABS($B10:$M10)<=P$3),P$3-ABS($B10:$M10))","v":2400},{"$f":"Q$3*12-P10-SUMPRODUCT(--(ABS($B10:$M10)<=Q$3),Q$3-ABS($B10:$M10))","v":9189},{"$f":"R$3*12-SUM($P10:Q10)-SUMPRODUCT(--(ABS($B10:$M10)<=R$3),R$3-ABS($B10:$M10))","v":80688},{"$f":"S$3*12-SUM($P10:R10)-SUMPRODUCT(--(ABS($B10:$M10)<=S$3),S$3-ABS($B10:$M10))","v":365099},null,{"$f":"(12*'Appendix F Pg 6'!$D$37)+(N10*(0.13441-0.00897))","v":60973.245439999999},0,60973.245439999999,null,{"$f":"(12*'Appendix F Pg 6'!$R$37)+(N10*'Appendix F Pg 6'!$R$39)","v":59546.232320000003},{"$f":"IF(N10<250000,(250000-N10)*'Appendix F Pg 6'!$R$39,0)","v":0},59546.232320000003]
["Total ID Sch 146",{"$f":"SUM(B5:B10)","v":351361},{"$f":"SUM(C5:C10)","v":263896},319671,325106,366317,327787,390472,245989,301343,312556,377238,340512,{"$f":"IF(ROUND(SUM(N5:N10),3)<>ROUND(SUM(B11:M11),3),#VALUE!,SUM(B11:M11))","v":3922248},null,null,null,null,null,null,{"$f":"SUM(U5:U10)","v":513606.78911999997},{"$f":"SUM(V5:V10)","v":0},{"$f":"SUM(W5:W10)","v":513606.78911999997},null,{"$f":"SUM(Y5:Y10)","v":501369.37536000001},{"$f":"SUM(Z5:Z10)","v":0},{"$f":"SUM(AA5:AA10)","v":501369.37536000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N11-N13","v":83210}]
["Revenue Runs",{"$f":"'Rev Runs CY'!C24","v":340512},{"$f":"'Rev Runs CY'!D24","v":351361},{"$f":"'Rev Runs CY'!E24","v":263896},{"$f":"'Rev Runs CY'!F24","v":319671},{"$f":"'Rev Runs CY'!G24","v":325106},{"$f":"'Rev Runs CY'!H24","v":344690},{"$f":"'Rev Runs CY'!I24","v":266204},{"$f":"'Rev Runs CY'!J24","v":390472},{"$f":"'Rev Runs CY'!K24","v":245989},{"$f":"'Rev Runs CY'!L24","v":301343},{"$f":"'Rev Runs CY'!M24","v":312556},{"$f":"'Rev Runs CY'!N24","v":377238},{"$f":"SUM(B13:M13)","v":3839038}]
["Unbilled",{"$f":"'Rev Runs CY'!D47","v":351361},{"$f":"'Rev Runs CY'!E47","v":263896},{"$f":"'Rev Runs CY'!F47","v":319671},{"$f":"'Rev Runs CY'!G47","v":325106},{"$f":"'Rev Runs CY'!H47","v":344690},{"$f":"'Rev Runs CY'!I47","v":327850},{"$f":"'Rev Runs CY'!J47","v":390472},{"$f":"'Rev Runs CY'!K47","v":233542},{"$f":"'Rev Runs CY'!L47","v":301097},{"$f":"'Rev Runs CY'!M47","v":312471},{"$f":"'Rev Runs CY'!N47","v":377072},{"$f":"'Rev Runs CY'!O47","v":340512},{"$f":"SUM(B14:M14)","v":3887740}]
["Unbilled Reversal",{"$f":"'Rev Runs CY'!D52","v":-340512},{"$f":"'Rev Runs CY'!E52","v":-351361},{"$f":"'Rev Runs CY'!F52","v":-263896},{"$f":"'Rev Runs CY'!G52","v":-319671},{"$f":"'Rev Runs CY'!H52","v":-325106},{"$f":"'Rev Runs CY'!I52","v":-344690},{"$f":"'Rev Runs CY'!J52","v":-266134},{"$f":"'Rev Runs CY'!K52","v":-390472},{"$f":"'Rev Runs CY'!L52","v":-233542},{"$f":"'Rev Runs CY'!M52","v":-301097},{"$f":"'Rev Runs CY'!N52","v":-312471},{"$f":"'Rev Runs CY'!O52","v":-377072},{"$f":"SUM(B15:M15)","v":-3826024},null,null,null,null,null,null,{"$f":"0.13441-0.00897","v":0.12544},36603]
["Unbilled True-Up",{"$f":"B11-B14-(B15+B13)-B17","v":0},0,0,0,{"$f":"F11-F14-(F15+F13)-F17","v":0},{"$f":"G11-G14-(G15+G13)-G17","v":-63},-70,12447,-12201,-161,81,-166,{"$f":"SUM(B16:M16)","v":-133}]
["Sched 146 Usage Adj (IFG)",0,0,0,0,21627,0,0,0,0,0,0,0,{"$f":"SUM(B17:M17)","v":21627}]
["Total Adj Calendar Sch 146",{"$f":"SUM(B13:B17)","v":351361},263896,319671,325106,366317,327787,390472,245989,301343,312556,377238,340512,3922248]
[null,{"$f":"B11-B18","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1st",200,1000,10000]
["ANNUAL USAGE, Sch 122",null,null,null,null,null,null,null,null,null,null,null,null,"12-mo ended",null,200,1000,10000,99999999]
["Idaho",{"$f":"B$4","v":"2022-01-01"},{"$f":"C$4","v":"2022-02-01"},"2022-03-01","2022-04-01","2022-05-01","2022-06-01","2021-07-01","2021-08-01","2021-09-01","2021-10-01","2021-11-01","2021-12-01","Total",null,"thms/mo","thms/mo","thms/mo","thms/mo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B23:M23)","v":0},null,{"$f":"P$21*12-SUMPRODUCT(--($B23:$M23<=P$21),P$21-$B23:$M23)","v":0},{"$f":"Q$21*12-SUM($P23:P23)-SUMPRODUCT(--($B23:$M23<=Q$21),Q$21-$B23:$M23)","v":0},{"$f":"R$21*12-SUM($P23:Q23)-SUMPRODUCT(--($B23:$M23<=R$21),R$21-$B23:$M23)","v":0},{"$f":"S$21*12-SUM($P23:R23)-SUMPRODUCT(--($B23:$M23<=S$21),S$21-$B23:$M23)","v":0}]
[]
["Total ID Sch 122",{"$f":"SUM(B23:B24)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(ROUND(SUM(N23:N24),3)<>ROUND(SUM(B25:M25),3),#VALUE!,SUM(B25:M25))","v":0},null,{"$f":"SUM(P23:P24)","v":0},{"$f":"SUM(Q23:Q24)","v":0},{"$f":"SUM(R23:R24)","v":0},{"$f":"SUM(S23:S24)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P25:S25)","v":0}]
["Revenue Runs",null,null,null,0,0,0,null,0,0,0,0,0,{"$f":"SUM(B27:M27)","v":0},null,{"$f":"P$21*12-SUMPRODUCT(--($B27:$M27<=P$21),P$21-$B27:$M27)","v":0},{"$f":"Q$21*12-SUM($P27:P27)-SUMPRODUCT(--($B27:$M27<=Q$21),Q$21-$B27:$M27)","v":0},{"$f":"R$21*12-SUM($P27:Q27)-SUMPRODUCT(--($B27:$M27<=R$21),R$21-$B27:$M27)","v":0},{"$f":"S$21*12-SUM($P27:R27)-SUMPRODUCT(--($B27:$M27<=S$21),S$21-$B27:$M27)","v":0}]
[null,null,null,null,0,0,0,null,0,0,0,0,0,{"$f":"SUM(B28:M28)","v":0},null,{"$f":"-P27","v":0},{"$f":"-Q27","v":0},{"$f":"-R27","v":0},{"$f":"-S27","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B29:M29)","v":0}]
["Total ID Sch 122",{"$f":"SUM(B27:B29)","v":0},{"$f":"SUM(C27:C29)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"B25-B30","v":0},{"$f":"C25-C30","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["ANNUAL USAGE, Sch 132",null,null,null,null,null,null,null,null,null,null,null,null,"12-mo ended"]
["Idaho",{"$f":"B$4","v":"2022-01-01"},{"$f":"C$4","v":"2022-02-01"},"2022-03-01","2022-04-01","2022-05-01","2022-06-01","2021-07-01","2021-08-01","2021-09-01","2021-10-01","2021-11-01","2021-12-01","Total"]
["St Joseph Regional",null,null,null,null,null,0,0,0,0,0,0,0,{"$f":"SUM(B35:M35)","v":0}]
[]
["Total ID Sch 132",{"$f":"SUM(B35:B36)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(ROUND(SUM(N35:N36),3)<>ROUND(SUM(B37:M37),3),#VALUE!,SUM(B37:M37))","v":0}]
[]
["Revenue Runs",{"$f":"'Rev Runs CY'!C23","v":0},{"$f":"'Rev Runs CY'!D23","v":0},{"$f":"'Rev Runs CY'!E23","v":0},{"$f":"'Rev Runs CY'!F23","v":0},{"$f":"'Rev Runs CY'!G23","v":0},{"$f":"'Rev Runs CY'!H23","v":0},{"$f":"'Rev Runs CY'!I23","v":0},{"$f":"'Rev Runs CY'!J23","v":0},{"$f":"'Rev Runs CY'!K23","v":0},{"$f":"'Rev Runs CY'!L23","v":0},{"$f":"'Rev Runs CY'!M23","v":0},{"$f":"'Rev Runs CY'!N23","v":0},{"$f":"SUM(B39:M39)","v":0}]
["St Joseph Regional",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B40:M40)","v":0},null,{"$f":"P$12*12-SUMPRODUCT(--(ABS($B40:$M40)<=P$12),P$12-ABS($B40:$M40))","v":0},{"$f":"Q$12*12-P40-SUMPRODUCT(--(ABS($B40:$M40)<=Q$12),Q$12-ABS($B40:$M40))","v":0},{"$f":"R$12*12-SUM($P40:Q40)-SUMPRODUCT(--(ABS($B40:$M40)<=R$12),R$12-ABS($B40:$M40))","v":0},{"$f":"S$12*12-SUM($P40:R40)-SUMPRODUCT(--(ABS($B40:$M40)<=S$12),S$12-ABS($B40:$M40))","v":0}]
["Total ID Sch 132",{"$f":"B39+B40","v":0},{"$f":"C39+C40","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"B37+B41","v":0},{"$f":"C37+C41","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["ANNUAL USAGE, Sch 147",null,null,null,null,null,null,null,null,null,null,null,null,"12-mo ended"]
["Idaho",{"$f":"B$4","v":"2022-01-01"},{"$f":"C$4","v":"2022-02-01"},"2022-03-01","2022-04-01","2022-05-01","2022-06-01","2021-07-01","2021-08-01","2021-09-01","2021-10-01","2021-11-01","2021-12-01","Total"]
["Aleris Recycling Inc (IMCO)",117339,124467,111052,121849,100276,133134,106450,83606,89292,104566,113268,108921,{"$f":"SUM(B46:M46)","v":1314220}]
[]
["Total ID Sch 147",{"$f":"SUM(B46:B47)","v":117339},124467,111052,121849,100276,133134,106450,83606,89292,104566,113268,108921,{"$f":"IF(ROUND(SUM(N46:N47),3)<>ROUND(SUM(B48:M48),3),#VALUE!,SUM(B48:M48))","v":1314220}]
[]
["Revenue Runs",{"$f":"'Rev Runs CY'!C25","v":117339},{"$f":"'Rev Runs CY'!D25","v":124467},{"$f":"'Rev Runs CY'!E25","v":111052},{"$f":"'Rev Runs CY'!F25","v":121849},{"$f":"'Rev Runs CY'!G25","v":100276},{"$f":"'Rev Runs CY'!H25","v":133134},{"$f":"'Rev Runs CY'!I25","v":106450},{"$f":"'Rev Runs CY'!J25","v":83606},{"$f":"'Rev Runs CY'!K25","v":89292},{"$f":"'Rev Runs CY'!L25","v":104566},{"$f":"'Rev Runs CY'!M25","v":113268},{"$f":"'Rev Runs CY'!N25","v":108921},{"$f":"SUM(B50:M50)","v":1314220},null,200,1000,10000,"Over"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B51:M51)","v":0},null,{"$f":"P$21*12-SUMPRODUCT(--(ABS($B51:$M51)<=P$21),P$21-ABS($B51:$M51))","v":0},{"$f":"Q$21*12-P51-SUMPRODUCT(--(ABS($B51:$M51)<=Q$21),Q$21-ABS($B51:$M51))","v":0},{"$f":"R$21*12-SUM($P51:Q51)-SUMPRODUCT(--(ABS($B51:$M51)<=R$21),R$21-ABS($B51:$M51))","v":0},{"$f":"S$21*12-SUM($P51:R51)-SUMPRODUCT(--(ABS($B51:$M51)<=S$21),S$21-ABS($B51:$M51))","v":0}]
["Total ID Sch 147",{"$f":"B50+B51","v":117339},124467,111052,121849,100276,133134,106450,83606,89292,104566,113268,108921,1314220]
[null,{"$f":"B48-B52","v":0},{"$f":"C48-C52","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["ANNUAL USAGE, Sch 159",null,null,null,null,null,null,null,null,null,null,null,null,"12-mo ended"]
["Idaho",{"$f":"B$4","v":"2022-01-01"},{"$f":"C$4","v":"2022-02-01"},"2022-03-01","2022-04-01","2022-05-01","2022-06-01","2021-07-01","2021-08-01","2021-09-01","2021-10-01","2021-11-01","2021-12-01","Total"]
["Clearwater 159",{"$f":"'Rev Runs CY'!C26","v":6474084},{"$f":"'Rev Runs CY'!D26","v":4301405},{"$f":"'Rev Runs CY'!E26","v":3452542},{"$f":"'Rev Runs CY'!F26","v":3568211},{"$f":"'Rev Runs CY'!G26","v":3329709},{"$f":"'Rev Runs CY'!H26","v":4342218},{"$f":"'Rev Runs CY'!I26","v":3496844},{"$f":"'Rev Runs CY'!J26","v":3116526},{"$f":"'Rev Runs CY'!K26","v":4215620},{"$f":"'Rev Runs CY'!L26","v":4711037},{"$f":"'Rev Runs CY'!M26","v":4858210},{"$f":"'Rev Runs CY'!N26","v":6046477},{"$f":"SUM(B57:M57)","v":51912883}]
[]
["Total ID Sch 159",{"$f":"SUM(B57:B58)","v":6474084},4301405,3452542,3568211,3329709,4342218,3496844,3116526,4215620,4711037,4858210,6046477,{"$f":"IF(ROUND(SUM(N57:N58),3)<>ROUND(SUM(B59:M59),3),#VALUE!,SUM(B59:M59))","v":51912883}]
[]
["Revenue Runs",{"$f":"'Rev Runs CY'!C26","v":6474084},{"$f":"'Rev Runs CY'!D26","v":4301405},{"$f":"'Rev Runs CY'!E26","v":3452542},{"$f":"'Rev Runs CY'!F26","v":3568211},{"$f":"'Rev Runs CY'!G26","v":3329709},{"$f":"'Rev Runs CY'!H26","v":4342218},{"$f":"'Rev Runs CY'!I26","v":3496844},{"$f":"'Rev Runs CY'!J26","v":3116526},{"$f":"'Rev Runs CY'!K26","v":4215620},{"$f":"'Rev Runs CY'!L26","v":4711037},{"$f":"'Rev Runs CY'!M26","v":4858210},{"$f":"'Rev Runs CY'!N26","v":6046477},{"$f":"SUM(B61:M61)","v":51912883}]
[null,{"$f":"B59-B61","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Actual Revenue check",6166.67,6166.67,6166.67,6166.67,6166.67,6166.67,6166.67,6166.67,6166.67,6166.67,6166.67,6166.67,{"$f":"SUM(B63:M63)","v":74000.039999999994}]
[]
[null,{"$f":"B56","v":"2022-01-01"},{"$f":"C56","v":"2022-02-01"},"2022-03-01","2022-04-01","2022-05-01","2022-06-01","2021-07-01","2021-08-01","2021-09-01","2021-10-01","2021-11-01","2021-12-01"]
["Pro-Forma Revenue",6166.67,6166.67,6166.67,6166.67,6166.67,6166.67,6166.67,6166.67,6166.67,6166.67,6166.67,6166.67,{"$f":"SUM(B66:M66)","v":74000.039999999994}]

{"sheet":"Rev Runs CY","index":11,"n_rows":70,"n_cols":18,"rows_kept":70,"cut":false,"hidden":false,"merged":[[6,16,7,16]]}
[]
["Weather Norm Sch/Class Rev 12 ME Report for 12ME 06.2022"]
[null,null,"Meters"]
[null,"Period","202201","202202","202203","202204","202205","202206","202107","202108","202109","202110","202111","202112","12 Month Average"]
["Rate Schedule Num",null,null,null,null,null,null,null,null,null,null,null,null,null,"Average","Total","Check to Bill Determ Tab"]
["101",101,86698,88299,96640,90163,90894,91039,88760,88922,89176,89465,89735,89898,{"$f":"AVERAGE(C6:N6)","v":89974.083333333328},{"$f":"SUM(C6:N6)","v":1079689},{"$f":"P6-'Bill Determ'!C8","v":0}]
["111",111,1440,1497,1759,1547,1565,1570,1552,1571,1547,1552,1548,1555,{"$f":"AVERAGE(C7:N7)","v":1558.5833333333333},{"$f":"SUM(C7:N7)","v":18703},{"$f":"P7+P8-'Bill Determ'!G12","v":0}]
["112",112,2,2,2,2,2,2,2,2,2,2,2,2,2,24]
["132",132,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"P9-'Bill Determ'!C25","v":0}]
["146",146,6,6,6,6,6,6,6,6,6,6,6,6,6,72,{"$f":"P10-'Bill Determ'!C29","v":0}]
["147",147,1,1,1,1,1,1,1,1,1,1,1,1,1,12,{"$f":"P11-'Bill Determ'!C32","v":0}]
["159",159,1,1,1,1,1,1,1,1,1,1,1,1,1,12,{"$f":"P12-'Bill Determ'!C35","v":0}]
["Total for ID","Total",{"$f":"SUM(C6:C12)","v":88148},{"$f":"SUM(D6:D12)","v":89806},98409,91720,92469,92619,90322,90503,90733,91027,91293,91463,{"$f":"SUM(O6:O12)","v":91542.666666666657},{"$f":"SUM(P6:P12)","v":1098512}]
[null,"Total per Bill Determ Report",88148,89806,98409,91720,92469,92619,90322,90503,90733,91027,91293,91463]
[null,"Check",{"$f":"C13-C14","v":0},{"$f":"D13-D14","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Usage"]
[null,"Period","202201","202202","202203","202204","202205","202206","202107","202108","202109","202110","202111","202112"]
["Rate Schedule Num",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total","Per 12ME 202206 Normalized Usage","Check"]
["101",101,12777739.25048,10888988.0151,10007004.61908,6675601.32565,5133720.6662499998,2818953.4783299998,1147387.9204599999,1027420.04583,1300221.0197099999,2867654.5582499998,5979568.89078,9402764.4140300006,{"$f":"SUM(C20:N20)","v":70027024.203949988},70027024.203950003,{"$f":"P20-O20","v":0}]
["111",111,3800925.7642600001,3425607.1834200001,3411362.32363,2307805.8774700002,2054432.3129,1467322.59608,907262.64002000005,903343.91758999997,1011581.79464,1366263.79575,2139277.7032599999,3011042.5723899999,{"$f":"SUM(C21:N21)","v":25806228.48141},25806228.48141,{"$f":"P21-O21","v":0}]
["112",112,1203.93,1265.375,993.39200000000005,15476.928,84208.546000000002,60746.813000000002,43194.894999999997,42556.406000000003,44795.995999999999,68952.432000000001,55105.071000000004,13144.323,431644.10699999996,431644.10700000002,0]
["132",132,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["146",146,340512,351361,263896,319671,325106,344690,266204,390472,245989,301343,312556,377238,3839038,3839038,0]
["147",147,117339,124467,111052,121849,100276,133134,106450,83606,89292,104566,113268,108921,1314220,1314220,0]
["159",159,6474084,4301405,3452542,3568211,3329709,4342218,3496844,3116526,4215620,4711037,4858210,6046477,51912883,51912883,0]
["Total for ID","Total",{"$f":"SUM(C20:C26)","v":23511803.944739997},{"$f":"SUM(D20:D26)","v":19093093.573520001},17246850.334710002,13008615.13112,11027452.525150001,9167064.88741,5967343.45548,5563924.3694199994,6907499.810349999,9419816.7860000003,13457985.665040001,18959587.309420001,153331037.79235998,153331037.79236001,0]
[null,"Total per Bill Determ Report",23511803.944740001,19093093.573520001,17246850.334709998,13008615.13112,11027452.525149999,9167064.88741,5967343.45548,5563924.3694200004,6907499.8103499999,9419816.7860000003,13457985.665039999,18959587.309420001]
[null,"Check",{"$f":"C27-C28","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Report Name:  Rev Norm Unbilled 12 ME Report for 12 ME 06.2022"]
[]
[]
[null,null,null,"Usage"]
[null,null,"Period","202201","202202","202203","202204","202205","202206","202107","202108","202109","202110","202111","202112","12 Month Total"]
["Source Id","Rate Schedule Num"]
["REVUNBL-G","101",null,6096027,5454469,2874189,2861803,1730648,760654,574868,686300,1045776,2903643,4612760,6890293,{"$f":"SUM(D45:O45)","v":36491430}]
[null,"111",null,1683439,1606594,916232,928548,647172,370330,422775,562058,757204,1280637,1537108,2054753,{"$f":"SUM(D46:O46)","v":12766850}]
[null,"146",null,351361,263896,319671,325106,344690,327850,390472,233542,301097,312471,377072,340512,3887740]
[null,"147",null,124467,111052,121849,100276,132757,154203,83606,95610,104442,113250,108850,117339,1367701]
[null,"Total for REVUNBL-G",null,{"$f":"SUM(D45:D48)","v":8255294},{"$f":"SUM(E45:E48)","v":7436011},4231941,4215733,2855267,1613037,1471721,1577510,2208519,4610001,6635790,9402897,54513721]
["REVUNBL-GR","101",null,-6890293,-6096027,-5454469,-2874189,-2861803,-1730648,-688490,-574868,-686300,-1045776,-2903643,-4612760,-36419266]
[null,"111",null,-2054753,-1683439,-1606594,-916232,-928548,-647172,-396052,-422775,-562058,-757204,-1280637,-1537108,-12792572]
[null,"146",null,-340512,-351361,-263896,-319671,-325106,-344690,-266134,-390472,-233542,-301097,-312471,-377072,-3826024]
[null,"147",null,-117339,-124467,-111052,-121849,-100276,-132757,-106430,-83606,-95610,-104442,-113250,-108850,-1319928]
[null,"Total for REVUNBL-GR",null,{"$f":"SUM(D50:D53)","v":-9402897},{"$f":"SUM(E50:E53)","v":-8255294},-7436011,-4231941,-4215733,-2855267,-1457106,-1471721,-1577510,-2208519,-4610001,-6635790,-54357790]
["Total for ID",null,null,{"$f":"D49+D54","v":-1147603},{"$f":"E49+E54","v":-819283},-3204070,-16208,-1360466,-1242230,14615,105789,631009,2401482,2025789,2767107,155931]
[null,null,"Total per Bill Determ Report",-1147603,-819283,-3204070,-16208,-1360466,-1242230,14615,105789,631009,2401482,2025789,2767107]
[null,null,"Check",{"$f":"D55-D56","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P45+P50","v":72164},"Schedule 101"]
[null,"Unbilled Adjustment",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P46+P51","v":-25722},"Schedule 111"]
[null,null,null,"202201","202202","202203","202204","202205","202206","202107","202108","202109","202110","202111","202112",null,"Per 12ME 062022 Normalized Usage","Check"]
[null,"101",null,{"$f":"D45+D50","v":-794266},{"$f":"E45+E50","v":-641558},-2580280,-12386,-1131155,-969994,-113622,111432,359476,1857867,1709117,2277533,{"$f":"SUM(D62:O62)","v":72164},72164,{"$f":"Q62-P62","v":0}]
[null,"111",null,{"$f":"D46+D51","v":-371314},{"$f":"E46+E51","v":-76845},-690362,12316,-281376,-276842,26723,139283,195146,523433,256471,517645,{"$f":"SUM(D63:O63)","v":-25722},-25722,{"$f":"Q63-P63","v":0}]
[null,"146",null,{"$f":"D47+D52","v":10849},{"$f":"E47+E52","v":-87465},{"$f":"F47+F52","v":55775},5435,19584,-16840,124338,-156930,67555,11374,{"$f":"N47+N52","v":64601},-36560,{"$f":"SUM(D64:O64)","v":61716},61716,{"$f":"Q64-P64","v":0}]
[null,"147",null,{"$f":"D48+D53","v":7128},{"$f":"E48+E53","v":-13415},10797,-21573,32481,21446,-22824,12004,8832,8808,-4400,8489,{"$f":"SUM(D65:O65)","v":47773},47773,{"$f":"Q65-P65","v":0}]
[null,null,null,{"$f":"SUM(D62:D65)","v":-1147603},{"$f":"SUM(E62:E65)","v":-819283},-3204070,-16208,-1360466,-1242230,14615,105789,631009,2401482,2025789,2767107,{"$f":"SUM(P62:P65)","v":155931},155931,{"$f":"Q66-P66","v":0}]
[]
[]
[]
[null,null,null,null,{"$f":"D47+E52","v":0},{"$f":"E47+F52","v":0},{"$f":"F47+G52","v":0},{"$f":"G47+H52","v":0},{"$f":"H47+I52","v":0},null,{"$f":"J47+K52","v":0},{"$f":"K47+L52","v":0},{"$f":"L47+M52","v":0},{"$f":"M47+N52","v":0}]

{"sheet":"Block Analysis","index":12,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,202201,{"$f":"D5+1","v":202202},{"$f":"E5+1","v":202203},202204,202205,202206,202107,202108,202109,202110,202111,202112,"YTD"]
["0111","BASIC CHARGE GAS",null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D6:O6)","v":0}]
[null,"NA",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"RIDER 150",null,-88,0,0,0,0,0,0,0,-239,0,-16,0,-343]
[null,"RIDER 155",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"RIDER 191",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"RIDER 197",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"THERMS BLOCK 1",null,{"$f":"284128.90681+D8","v":284040.90681000001},295876.08915999997,346320.96599,303873.36193999997,302650.86686000001,276186.19965999998,195638.88049000001,189669.48684999999,{"$f":"209450.96251+L8","v":209211.96251000001},267475.24956000003,{"$f":"301280.69327+N8","v":301264.69326999999},307651.3455,3279860.0085999998]
[null,"THERMS BLOCK 2",null,997999.01231999998,1002299.73858,1089366.79507,825927.30275000003,716517.51402,495499.45036000002,302102.20481999998,294615.01308,329976.98569,460128.05351,753625.96169000003,967960.50832999998,8236018.5402199989]
[null,"THERMS BLOCK 3",null,2001075.7461300001,1718455.9686799999,1626777.6235700001,971334.13378000003,791605.14402000001,508733.34706,261621.13670999999,264154.63166000001,289277.30842000002,430206.58768,833809.00430000003,1427739.6615599999,11124790.293570001]
[null,"THERMS BLOCK 4",null,517810.09899999999,408975.38699999999,348896.93900000001,206671.079,243658.788,186903.59899999999,147900.41800000001,154904.78599999999,183115.53802000001,208453.905,250578.04399999999,307691.05699999997,3165559.6390199997]
[null,"Total for 0111",null,{"$f":"SUM(D12:D15)","v":3800925.7642600001},{"$f":"SUM(E12:E15)","v":3425607.1834200001},3411362.3236300005,2307805.8774699997,2054432.3129,1467322.59608,907262.64002000005,903343.91758999997,1011581.79464,1366263.79575,2139277.7032599999,3011042.5723899999,25806228.481410004]
[null,null,"Check to Rev Runs",{"$f":"D16-'Rev Runs CY'!C21","v":0},{"$f":"E16-'Rev Runs CY'!D21","v":0},{"$f":"F16-'Rev Runs CY'!E21","v":0},{"$f":"G16-'Rev Runs CY'!F21","v":0},{"$f":"H16-'Rev Runs CY'!G21","v":0},{"$f":"I16-'Rev Runs CY'!H21","v":0},{"$f":"J16-'Rev Runs CY'!I21","v":0},{"$f":"K16-'Rev Runs CY'!J21","v":0},{"$f":"L16-'Rev Runs CY'!K21","v":0},{"$f":"M16-'Rev Runs CY'!L21","v":0},{"$f":"N16-'Rev Runs CY'!M21","v":0},{"$f":"O16-'Rev Runs CY'!N21","v":0},0,{"$f":"P17/P16","v":0}]
[]
[null,null,null,{"$f":"D5","v":202201},{"$f":"E5","v":202202},202203,202204,202205,202206,202107,202108,202109,202110,202111,202112,"YTD"]
[112,"BASIC CHARGE GAS",null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D20:O20)","v":0}]
[null,"NA",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"RIDER 150",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"RIDER 155",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"RIDER 191",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"RIDER 197",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"THERMS BLOCK 1",null,200,200,200,400,400,238.773,202.626,200,200,394.76400000000001,400,400,{"$f":"SUM(D26:O26)","v":3436.163}]
[null,"THERMS BLOCK 2",null,800,800,793.39200000000005,1361.8040000000001,1039.2370000000001,800,800,800,800,800,1328.3009999999999,1527.5730000000001,{"$f":"SUM(D27:O27)","v":11650.307000000001}]
[null,"THERMS BLOCK 3",null,203.93,265.375,0,9000,9000,9000,9000,9000,9000,9000,9000,9000,{"$f":"SUM(D28:O28)","v":81469.304999999993}]
[null,"THERMS BLOCK 4",null,null,null,null,4715.1239999999998,73769.308999999994,50708.04,33192.269,32556.405999999999,34795.995999999999,58757.667999999998,44376.77,2216.75,{"$f":"SUM(D29:O29)","v":335088.33199999999}]
[null,"Total for 0111",null,{"$f":"SUM(D26:D29)","v":1203.93},{"$f":"SUM(E26:E29)","v":1265.375},993.39200000000005,15476.928,84208.546000000002,60746.813000000002,43194.895000000004,42556.406000000003,44795.995999999999,68952.432000000001,55105.070999999996,13144.323,{"$f":"SUM(D30:O30)","v":431644.10699999996}]
[null,null,"Check to Rev Runs",{"$f":"D30-'Rev Runs CY'!C22","v":0},{"$f":"E30-'Rev Runs CY'!D22","v":0},{"$f":"F30-'Rev Runs CY'!E22","v":0},{"$f":"G30-'Rev Runs CY'!F22","v":0},{"$f":"H30-'Rev Runs CY'!G22","v":0},{"$f":"I30-'Rev Runs CY'!H22","v":0},{"$f":"J30-'Rev Runs CY'!I22","v":0},{"$f":"K30-'Rev Runs CY'!J22","v":0},{"$f":"L30-'Rev Runs CY'!K22","v":0},{"$f":"M30-'Rev Runs CY'!L22","v":0},{"$f":"N30-'Rev Runs CY'!M22","v":0},{"$f":"O30-'Rev Runs CY'!N22","v":0}]